drawingblank
11-27-2022, 05:24 PM
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
Private Sub Workbook_Open()
If userclicks.notify then
do this
Else 'when user clicks Read only
end if
End Sub
Thanks
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
Private Sub Workbook_Open()
If userclicks.notify then
do this
Else 'when user clicks Read only
end if
End Sub
Thanks