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!