[RESOLVED] Trap Unprotect Event

[doasidont]

Is there any way to trap an event in which a user unprotects a sheet or workbook so that I can force some addtional requirements (like user-id). Or, is there a way to disable the 'Unprotect' menu command (so that I can create my own QAT button to do unprotects)? I do not want to simply protect a sheet or workbook with a password. I want to add additional requirements before a user can unprotect something and also log the user and time that this action was performed. Thanks.

[Siddharth Rout]

I could be wrong but there is no way to trap the user unprotecting/protecting the sheet. You can however disable the option by protecting the workbook...

Similarly there is no way to trap the user unprotecting/protecting the workbook

[doasidont]

Protecting the workbook to disable the option to unprotect any sheet would be okay, but I can't get it to work. I protect the workbook, but after that, I can still protect / unprotect any sheet. What am I missing? Thanks.

[anhn]

"Protect Workbook" will not allow you to add, move, delete, hide/unhide sheets but it has no effect on protect/unprotect sheets.

"Protect Shared Workbook" will disable all other Protect/Unprotect options for sheet/workbook. That also locks the VBA project.

Shared workbook will have some side effect if you don't mind. You also can set "Don't keep change history" to True (default is to keep for 30 days).

[doasidont]

Thanks. Looks like Protect Shared Workbook also prevents me from creating my own 'Unprotect' button, which is what I need. Is there any other way to remove or disable the 'Unprotect/Protect' sheet icon on the Review tab?

[doasidont]

Answer became obvious to me. I'll protect the sheets using a password known only to certain people. Then I'll create a new button on the QAT that will be used to unprotect the sheet but only after other user conditions are met.