A
angelasg
First of all, I'm using Excel 2002
I have some code like this:
Private Sub Worksheet_Deactivate()
'look for a value in a certain cell on the sheet the user just
deactivated
'if a certain value is there, go back to the sheet the user just
deactivated
'essentially, the user can't go to any other sheet unless they change
the value of a certain cell first
End Sub
The code works fine EXCEPT when the user clicks on a sheet with
grouped rows and/or columns that have any of those groups collapsed.
When that happens, Excel stays on the sheet they just clicked and
whatever cell was last activated blinks black and white.
This seems like a bug to me. Am I doing something wrong? Is this a
known issue?
Any help would be appreciated. If you need more detail, please let me
know.
Thanks.
I have some code like this:
Private Sub Worksheet_Deactivate()
'look for a value in a certain cell on the sheet the user just
deactivated
'if a certain value is there, go back to the sheet the user just
deactivated
'essentially, the user can't go to any other sheet unless they change
the value of a certain cell first
End Sub
The code works fine EXCEPT when the user clicks on a sheet with
grouped rows and/or columns that have any of those groups collapsed.
When that happens, Excel stays on the sheet they just clicked and
whatever cell was last activated blinks black and white.
This seems like a bug to me. Am I doing something wrong? Is this a
known issue?
Any help would be appreciated. If you need more detail, please let me
know.
Thanks.