Protection prompt for a workbook is not working correctly for One user

[troyh68]

I have a user that uses a shared workbook once or twice a month. In the past she would get a prompt asking for a password to be able to make changes. Today she opened the spreadsheet and the prompt did not open. The spreadsheet still opened in Read Only mode however when she tries to save it will not allow her to do so. i am thinking that she has checked the box to not show this message again. If she does make a change and tries to save the file it gives her the "File is read only to save changes....." message box. When she tries to save as it will allow those changes however it does not allow her to save over the existing file because it is open in Read Only mode. How can I get the message to prompt her to give the password again. One last thing. The file was originally in Excel 2003 running in compatibility mode in Excel 2016.

 

[BarryL]

see if she has events disable. get her to run the below

sub enab()
application.EnableEvents = True
End Sub

 

[troyh68]

see if she has events disable. get her to run the below

sub enab()
application.EnableEvents = True
End Sub

BarryL
thank you