Excel Automatic Macro

  hemmy 14:09 03 May 04
Locked

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 04

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

  hemmy 17:38 03 May 04

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.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

This poetic animation about monsters is illustrated in a Van Gogh painterly style

Apple predictions 2017