View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
michdenis michdenis is offline
external usenet poster
 
Posts: 135
Default 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