The Tamer
02-10-2005, 01:41 AM
Hi guys,
I have an irritating side effect on one of my macros.
I have saved some custom views in my sheet - they show or hide columns depending on what the user has input in Column E on the last record. The custom view puts the active cell where it was when the view was set. So I have the following Macro on the Worksheet_Calculate doo-da:
Private Sub Worksheet_Calculate()
On Error Resume Next
Set UserCell = ActiveCell
ThisWorkbook.CustomViews(Me.Range("AA1").Value).Show
UserCell.Activate
End Sub
Problem is, though the cell the user was on is re-selected, the validation dropdown arrow is mysteriously stuck on the cell that the CustomView selected.
Huh? It's not major - but can anyone help? (Excel 97)
Cheers
I have an irritating side effect on one of my macros.
I have saved some custom views in my sheet - they show or hide columns depending on what the user has input in Column E on the last record. The custom view puts the active cell where it was when the view was set. So I have the following Macro on the Worksheet_Calculate doo-da:
Private Sub Worksheet_Calculate()
On Error Resume Next
Set UserCell = ActiveCell
ThisWorkbook.CustomViews(Me.Range("AA1").Value).Show
UserCell.Activate
End Sub
Problem is, though the cell the user was on is re-selected, the validation dropdown arrow is mysteriously stuck on the cell that the CustomView selected.
Huh? It's not major - but can anyone help? (Excel 97)
Cheers