I am trying to enter code that will disable (gray out) a checkbox when the sheet on which it resides is protected, and become active when the sheet is made to be unprotected (password is involved). I am working with Excel 2007. I'm new to VBA.
I am trying to enter code that will disable (gray out) a checkbox when the sheet on which it resides is protected, and become active when the sheet is made to be unprotected (password is involved). I am working with Excel 2007. I'm new to VBA.
Last edited by MontySmall; 05-30-2013 at 10:58 PM.
Hi MontySmall,
WELCOME TO THE FORUM!
Try below code and refer attached workbook (password is involved).
Don't forget to set thread SOLVED and click *
![]()
Please Login or Register to view this content.
Cheers,
Joshi
Being with a winner makes you a winner
Joshi,
Thanks a million!
MontySmall
Hi MontySmall,
You are welcome. Glad I could help. If the code is ok, please mark the post as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks