Excel Automatic Macro

  hemmy 14:09 03 May 04

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.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

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

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…