Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 100
Default Problem with validation arrows

I have data validation in two columns. Normally, you click on a cell and the
dropdown arrow appears in that cell. Something happened and now the arrow
appears just to the left of B6 and doesn't move no matter where you click. If
the cell you're in contains a dropdown list, the arrow functions even though
it's in a strange place. If the cell you're in does not contain a dropdown
list, the arrow is there, but it doesn't do anything.

Additionally, if I right-click on the tab name and choose View Code. I've
got this code in Worksheet selection. I don't know how to delete it or if it
has anything to do with the arrow problem.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

Please help.

Thanks,
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 100
Default Problem with validation arrows

I recreated the worksheet and deleted the problem sheet then fixed all of the
#REF errors that happened because I deleted a sheet. The arrows work now, but
the code it still there. I'm curious why this happened and if there's
anything I can do to stop it from happening again, and what the code means.

Thanks,

"sb1920alk" wrote:

I have data validation in two columns. Normally, you click on a cell and the
dropdown arrow appears in that cell. Something happened and now the arrow
appears just to the left of B6 and doesn't move no matter where you click. If
the cell you're in contains a dropdown list, the arrow functions even though
it's in a strange place. If the cell you're in does not contain a dropdown
list, the arrow is there, but it doesn't do anything.

Additionally, if I right-click on the tab name and choose View Code. I've
got this code in Worksheet selection. I don't know how to delete it or if it
has anything to do with the arrow problem.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

Please help.

Thanks,

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 100
Default Problem with validation arrows

Ok, now when I open the file, it's asking me if I want to enable macros. Any
macros in this file are unintentional. The only thing I can think of is that
piece of code, and it won't stay deleted.

Please help.

Thanks,

"sb1920alk" wrote:

I recreated the worksheet and deleted the problem sheet then fixed all of the
#REF errors that happened because I deleted a sheet. The arrows work now, but
the code it still there. I'm curious why this happened and if there's
anything I can do to stop it from happening again, and what the code means.

Thanks,

"sb1920alk" wrote:

I have data validation in two columns. Normally, you click on a cell and the
dropdown arrow appears in that cell. Something happened and now the arrow
appears just to the left of B6 and doesn't move no matter where you click. If
the cell you're in contains a dropdown list, the arrow functions even though
it's in a strange place. If the cell you're in does not contain a dropdown
list, the arrow is there, but it doesn't do anything.

Additionally, if I right-click on the tab name and choose View Code. I've
got this code in Worksheet selection. I don't know how to delete it or if it
has anything to do with the arrow problem.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

Please help.

Thanks,

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 100
Default Problem with validation arrows

Ok, now when I open the file, it's asking me if I want to enable macros. Any
macros in this file are unintentional. The only thing I can think of is that
piece of code, and it won't stay deleted.

Please help.

Thanks,

"sb1920alk" wrote:

I recreated the worksheet and deleted the problem sheet then fixed all of the
#REF errors that happened because I deleted a sheet. The arrows work now, but
the code it still there. I'm curious why this happened and if there's
anything I can do to stop it from happening again, and what the code means.

Thanks,

"sb1920alk" wrote:

I have data validation in two columns. Normally, you click on a cell and the
dropdown arrow appears in that cell. Something happened and now the arrow
appears just to the left of B6 and doesn't move no matter where you click. If
the cell you're in contains a dropdown list, the arrow functions even though
it's in a strange place. If the cell you're in does not contain a dropdown
list, the arrow is there, but it doesn't do anything.

Additionally, if I right-click on the tab name and choose View Code. I've
got this code in Worksheet selection. I don't know how to delete it or if it
has anything to do with the arrow problem.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

Please help.

Thanks,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation problem xami Excel Worksheet Functions 2 March 6th 06 11:12 AM
Data validation problem Jamuck Excel Discussion (Misc queries) 4 January 26th 06 05:03 PM
Remove Duplication from Validation List? [email protected] Excel Discussion (Misc queries) 1 January 17th 06 03:27 AM
Copy workbook- Validation function sjs Excel Worksheet Functions 3 December 28th 05 04:00 PM
Validation problem... BeSmart Excel Worksheet Functions 3 July 7th 05 03:22 AM


All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright Đ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"