Update PowerPoint presentation with linked Excel objects without displaying Excel macro warnings?
Posted on 2009-04-07
Is there any way to prevent the Excel macro warning message from being generated when updating linked objects within a Powerpoint presentation?
I have a large presentation fed by over 30 separate workbooks, all of which use automation to collate the required data and charts and therefore contain macros. I have developed a Powerpoint addin to find and replace text in the links, e.g. to point the link to a newer version of the file in another folder. This works fine but I get the annoying message for every file and have to press "Enable" or "Disable".
Any help hugely appreciated!