EE Pros, I have a GREAT WS that Martin Liss has been instrumental in helping me get it to this point. I'm attempting to now establish password protection on the cells/fields so as to insure the formulas and macros do not get messed up. I've attached the WB/WS for your review. It has a Private Sub that triggers a checkmark in Col. A that doesn't work if I protect the WS. I have Unlocked all of the cells that I want to make accessible and all others are coded for lock when password protection is on. My understanding is that I may be able to issue a macro/command that will allow macros to do what they need to do within a WS without having to code each one.
Thank you in advance.