Macro Autostart when opening a file

  • Thread starter Thread starter Snoopy
  • Start date Start date
S

Snoopy

Hey guys
I want to start a (series of) macros start directly when opening an
EXCEl-reporting file. I'm certain the must be an easy command - to
whom with the knowlegde...

Will one of you out there kindly give me a hand on this?

Best regards
Snoopy
 
Create a macro named Auto_Open() in a regular  module.  Then in it call the
macros you want to have run on startup.

Sub  Auto_Open()
    macroname1
    macroname2
    macronamex
End Sub

Robert Flanaganhttp://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel








– Vis sitert tekst –
Click to expand...

Thanks a lot Bob :)))
 
Create a macro named Auto_Open() in a regular  module.  Then in it call the
macros you want to have run on startup.

Sub  Auto_Open()
    macroname1
    macroname2
    macronamex
End Sub

Robert Flanaganhttp://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel








– Vis sitert tekst –
Click to expand...

Bob
I tryed this macro to approve the links update, but I still get the
message poping up on the screen....as well as message to activate
macros.
Are there any way around to make the macro approve the choices and
"skip" the messages automaticly when opening the file?

I have looked at the edit connection options and defined the option
that will approve the connections without user message, but this will
not work - even by manual prosedure.


Sub Auto_Open()
ActiveWorkbook.UpdateLinks = xlUpdateLinksAlways
End Sub

Stil hope for more help on this

Regards
Snoopy
 
Back
Top