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

  • Thread starter Thread starter Ken Soenen
  • Start date Start date
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 ?
 
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
How to Unlock Excel Workbook protected by MACRO Password 6
Lose macros before saving 4
Using macros to open a file with the Find Menu option available 5
Need to run a macro on opening a new excel file 0
How to code it on macro ? 10
Unable to change ActiveSheet within Workbook_Open 2
Application.OnTime - Macro Cannot Be Found - Internet Explorer 0

Back
Top