Hi
How do I get the macro to automatically select 'yes' when presented with this box (see attachment) when I open the spreadsheet?:
Attachment: Attachment 164493
Macro Code as follows:
The macro is designed to re share the workbook when opened first thing in the morning as a macro ran later in the day removes shared access and several people need access to the spreadsheet during the day.The shared access is removed later in the day due to a button which is pressed to save down the file into a different folder and in order to do that shared access needs removing first.
Any help gratefully appreciated.
Many Thanks
Andrew
Bookmarks