Using the Event Handler
Posted by brian charles on May 05, 2000 10:45 AM
As i have never used the event handler before, I am
having difficulties. I found a reference on the web,
that led me to create the following code, but it does
not run. I would like to run the macro "SpadeChartSetup"
upon activating the sheet named "Chart".
ANy help is greatly appreciated.
Public WithEvents appevent As Application
Private Sub appevent_SheetActivate(ByVal Sh As Object)
If ActiveSheet.Name = Chart Then