View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Run worksheet level macro in a macro

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!