Hello, I have a struggle with this:
It's for a test and it is supposed to lock the answer cells when you type "done" in B18. It doesn't work when the sheet is locked, it gives me unable to change protection of the range class message, however when the sheet is unlocked it changes the state of the cell from locked to unlocked and vice versa, just as it should. I am quite new to VBA and I have no idea if it is even possible to do. Could anyone help me? Thanks.Please Login or Register to view this content.
Bookmarks