My workbook includes three sheets. Each of them has locked cells. The Sheets all currently have code on the Sheet to protect the sheet when it is activated and different code when they are deactivated. The code is different on each as the requirements for Protection are different - some allow locked cells to be selected - others don't.
What would the code look like to do the following and where would the code sit - on the sheets or as a call ??
If one of the Sheets becomes unprotected then the other two are set to Unprotect and when none of the Sheets has been active for 60 seconds then each of eth sheets becomes protected.
Thank You
Allister
Bookmarks