How to run a macro automatically when the file is opened?


L

LunaMoon

Hi all,

I often have to click a macro button after opening an Excel 2003
workbook...

Is there a way to open the file and automatically run the macro
immediately after opening the file without me sitting there and click
and waiting?

Thanks!
 
Ad

Advertisements

D

Dave Peterson

This may work--but it depends on what that other macro does and what kind of
button you click on to run it.

You could create a new macro in a General module:

Option Explicit
Sub Auto_Open()
call YourExistingMacroNameGoesHere
end sub
 

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

Top