Macro Autostart when opening a file

[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

 

[Snoopy]

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

Sub  Autpen()
    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 –

Thanks a lot Bob ))

 

[Snoopy]

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

Sub  Autpen()
    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 –

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 Autpen()
ActiveWorkbook.UpdateLinks = xlUpdateLinksAlways
End Sub

Stil hope for more help on this

Regards
Snoopy