Excel Automatic Macro

  hemmy 14:09 03 May 2004

Excel help has let me down again.
It tells me how to stop automatic macros from running when I open a spreadsheet but not how to create one.

I have several spreadsheets that all link to a Word document object for the address heading. Everytime I open one of the spreadsheets it asks if I want to update the link. This is annoying.

I want a macro that will run as soon as the spreadsheet is opened and do the update for me.

  VoG II 14:12 03 May 2004

Call the macro Auto_Open and it will run automatically when you open the workbook.

  hemmy 17:38 03 May 2004

Thanks VoG™

I knew it would be something semi obvious but Monopolysoft just didn't want me to find it

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?