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

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone