Run macro when user selects a different sheet
Hi,
Your code is fine so I guess you have it in the wrong place. It's 'Workbook'
event code so double click 'This Workbook' and paste the code in on the right.
Mike
"CraigKer" wrote:
I need to run a macro when a user selects a different sheet within my
workbook. I tried using the following code as a test in module 1 with some
other code i wrote:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If ActiveSheet.Name = "Info" Then
MsgBox "made it to info"
Else
MsgBox "not info"
End If
End Sub
However, this does not work. When I change the active sheet in the workbook
nothing happens. Do I need to put this code somewhere else?
Thanks in advance...
|