run a macro automatically upon opening an XLS file???

K

Ken Soenen

Is there any way to run a given macro automatically upon opening an Excel
file, rather than opening the file and then Tools/macro/macros.../Run ?
 
B

bplumhoff

Hi Ken,

Yes: Call that macro auto_open().

It will be auto-executed when the.xls is opened unless the user presses
the shift key during open.

HTH,
Bernd
 

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
VBA Digital Signature not working 3
Auto Run Macro Upon Entry 2
Using macros to open a file with the Find Menu option available 5
how to run a recorded macro in many files at a same time 1
How to code it on macro ? 10
startup macro does not execute 3
Macro needed to set macro security in Excel to minimum 3

Top