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.
Call the macro Auto_Open and it will run automatically when you open the workbook.
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 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
© Copyright 2017 IDG UK. All Rights Reserved.