Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data validation problem | Excel Worksheet Functions | |||
Data validation problem | Excel Discussion (Misc queries) | |||
Remove Duplication from Validation List? | Excel Discussion (Misc queries) | |||
Copy workbook- Validation function | Excel Worksheet Functions | |||
Validation problem... | Excel Worksheet Functions |