View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alex J Alex J is offline
external usenet poster
 
Posts: 85
Default Run worksheet level macro in a macro

Chip,
That's the VBA name for the sheet as opposed to the worksheet name as
displayed on the worksheet tab, right?
AlexJ

"Chip Pearson" wrote in message
...
If you change the declaration of the Activate procedure from
Private to Public, you can call it from any macro. E.g.,

Sheet1.Worksheet_Activate


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Wandering Mage" wrote in
message ...
I am trying to launch a worksheet level (on sheet
activated) event from another macro. I do not want to
actually activate the sheet to get it to run though. Is
there any way that I can do this? Let me know, and thank
you in advance for the help!