Problem with validation arrows

S

sb1920alk

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,
 
S

sb1920alk

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,
 
S

sb1920alk

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,
 
S

sb1920alk

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top