Run worksheet level macro in a macro

  • Thread starter Thread starter Wandering Mage
  • Start date Start date
W

Wandering Mage

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!
 
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
 
Chip,
That's the VBA name for the sheet as opposed to the worksheet name as
displayed on the worksheet tab, right?
AlexJ
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Run Macro on All Sheets Q 8
Run macro from active workbook whose name keeps changing 20
Run macro on all files in a specific folder 3
Macro shortcuts are running macros in different open workbook 3
run all worksheet macros 11
Macro Related to Paste Values 2
Run two macros for two different sheets 11

Back
Top