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:

Please Login or Register  to view this content.
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