I am looking for a macro within Excel for Mac 2011 to open a presentation and update the charts that are in it. The charts that are in the presentation are located within the report in the 'Charts of SRs' tab. On the 'Table of Contents' tab, there is a button that says "Create Presentation" and I would like for the macro to be placed in there. The user will have both this report and powerpoint hand in hand but I want them to still be prompted to open the presentation to confirm that it is able to be updated. If they do not have the file or it can't be recognized, the user is informed that the presentation could not be updated.