| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Deactivation Event
I am trying to enable a macro to run when a particular worksheet is
deselected. Thus far I have followed the directions on this web page: http://exceltips.vitalnews.com/Pages...tiva ted.html However I am recieving an error: Cannot Find FileName!MacroName. I am asking for either help with this method to correct the error or if anyone knows a different method--I don't mind doing it in VBA, I just don't know how yet. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet Deactivation Event
Place the following code in the worksheet code area
Private Sub Worksheet_Deactivate() Call MyMacro End Sub -- Cheers Nigel "DynamiteSkippy" wrote in message ... I am trying to enable a macro to run when a particular worksheet is deselected. Thus far I have followed the directions on this web page: http://exceltips.vitalnews.com/Pages...tiva ted.html However I am recieving an error: Cannot Find FileName!MacroName. I am asking for either help with this method to correct the error or if anyone knows a different method--I don't mind doing it in VBA, I just don't know how yet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with worksheet event | Excel Worksheet Functions | |||
| Prevent deactivation of sheet | Excel Programming | |||
| Event Procedures: Event on Worksheet to fire Event on another Worksheet | Excel Programming | |||
| Copying Worksheet triggers Click event of combobox on another worksheet | Excel Programming | |||
| macro to apply worksheet event to active worksheet | Excel Programming | |||
Hybrid Mode
