Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro when user selects a different sheet
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Selects Directory to Save File Based on Sheet Criteria | Excel Programming | |||
Start Macro after user selects a choice from a pick list | Excel Discussion (Misc queries) | |||
Record the time a user selects a macro | Excel Programming | |||
pause macro until user selects correct range | Excel Programming | |||
Cancel Macro is user selects 'cancel' at save menu | Excel Programming |