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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…