Hi,
I have an excel (365) file in a share folder. The file has the 'Read only recommended' when opening. Is there a way to detect when a user clicks on the 'Notify' option and the macro will action a segment of codes? eg
ThanksPrivate Sub Workbook_Open() If userclicks.notify then do this Else 'when user clicks Read only end if End Sub