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
|
|