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,

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,

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,

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,