Running a macro on open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get a macro to run when the .xls file is opened? I recalled having to name it Autoexec and then it would automatically run when file was opened ..

Thanks in advance for any help!
 
Hi
two ways:
1. In your workbook module (not in a standard module) use the
Workbook_Open() event procedure

2. Rename your macro to Auto_Open()

--
Regards
Frank Kabel
Frankfurt, Germany
Donna Watling said:
How do I get a macro to run when the .xls file is opened? I recalled
Click to expand...
having to name it Autoexec and then it would automatically run when
file was opened ...
 
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
How to code it on macro ? 10
How to Unlock Excel Workbook protected by MACRO Password 6
Unable to change ActiveSheet within Workbook_Open 2
Opening a list of Excel files and run a macro in each 17
Application.OnTime - Macro Cannot Be Found - Internet Explorer 0
Need to run a macro on opening a new excel file 0
VBA insert column with two workbooks open 1

Back
Top