Lock unlock history

[DroZ3]

I made a fairly complex sheet which I locked to prevent users to modify formulas.
Password was given to my manager, no choice, but I was made aware the password is circulating among some users.
Is there a way for me to know if the sheet was unlocked then relocked ???

 

[VBE313]

No

 

[Jaafar Tribak]

If youe referring to sheet protection as opposed to workbook protection then you may find this thread useful :

How to control multiple Sheets in the same Workbook

I am interested in an extended VBA code solution at this link How to tell if someone unprotected a worksheet (by author @Jaafar Tribak). If I have multiple sheets. All Sheets contain some locked cells, Sheet is protected. How to control multiple Sheets in the same Workbook (eg Sheet1, Sheet2...

www.mrexcel.com

 

[DroZ3]

Jaafar, thanks for the link, I will try to incorporate the monitoring to my sheets.

Since I have to support the users on the spreadsheets I create I need to make sure someone did not unlock the sheet to improperly modify formulas and the relock the sheet without saying a word about it ... Now that I have started using array formulas this becomes even more of an issue as users don't have a clue about the CTRL+SHIFT+ENTER.