Thread
:
Macro to open file bypasses Auto_Open
View Single Post
#
4
Posted to microsoft.public.excel.programming
michdenis
external usenet poster
Posts: 135
Macro to open file bypasses Auto_Open
Hi,
a simple example of a code you could use
in your file to open
http://cjoint.com/?bjfjH1n6v0
"Steven" a écrit dans le message de groupe de
discussion :
...
I have the following code.
Workbooks.Open Filename:=vOpen, UpdateLinks:=3
But when I run this it does not process the macro Auto_Open.
Why is this?
I would like for code to run on the opening of the file regardless of how
the user opened it. (ie. If they opened it using File / Open on the menu
then yes, the Auto_Open would run. But I also want code to run even if
they write their own macro to open it.)
Thank you,
Steven
Reply With Quote
michdenis
View Public Profile
Find all posts by michdenis