| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running Macro at sheet activation
I would like to have a macor run when certain pages are opened. This
is what I have tried... Private Sub Worksheet_Activate () Application.Run "Macroname" End Sub All I get is the screen flashing at me about 50 times and the macro doesn't run. My hope is to have a macro run on activation and another run on deactivation. I'm looking for the correct wording. I could sure use some help. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Filtered Subtotal - require sheet activation? | Excel Programming | |||
| Sheet activation | Excel Discussion (Misc queries) | |||
| Changing the activation of a sheet that is unactive and undefined | Excel Programming | |||
| macro on Sheet activation | Excel Programming | |||
| Sheet protection error msg - Unrequested sheet activation | Excel Programming | |||
![gfkbob[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
