Automatic unprotect all sheet when go to a particular sheet

[kuldeepnagar]

Hi All
I have sheet 1 with many (around 150) check boxes. These check boxes operates 150 macros on sheet2, sheet3 and sheet4. These sheets are password protected. Each marco is with IF ELSE condition.

Is there any way/vba code that as soon as i go to sheet1, all remaining 3 sheet gets unlocked and when i leave sheet1, all remaining 3 sheets gets locked so that i can operated all check boxes without entering password in macros.

Many thanks for your support.

Kind Regards
Kuldeep

 

[Fluff]

Cross posted https://chandoo.org/forum/threads/a...l-sheets-when-go-to-a-particular-sheet.41764/

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[kuldeepnagar]

Sure Dear Fluff, I'll take care about it. Can you please support me on this since i am approaching deadline to submit it?
Many thanks in advance.

Kind Regards
Kuldeep