Hi
How do I get the macro to automatically select 'yes' when presented with this box (see attachment) when I open the spreadsheet?:
Attachment: replace.JPG
Macro Code as follows:
Sub Unshare()
If ActiveWorkbook.MultiUserEditing Then
ActiveWorkbook.ExclusiveAccess
Application.DisplayAlerts = False
End If
End Sub
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.
I'm reasonably good on Excel, but VB is definitely not my strong point. Any help gratefully appreciated.
Many Thanks
Andrew
Bookmarks