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

  • Follow


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!
0
Reply LunaMoon 4/23/2010 11:23:02 PM

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



LunaMoon wrote:
> 
> 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!

-- 

Dave Peterson
0
Reply Dave 4/24/2010 12:01:34 AM


1 Replies
376 Views

(page loaded in 0.103 seconds)


Reply: