Sheet Protection / Edit Objects
Help please,
Problem 1: I have a spreadsheet with multiple objects that I'm trying to lock. My problem is I also have cells that I need to have comment insertion capabilites. When going to Tools/Protection/Protect Sheet and allow Edit Objects is checked I can insert a comment. However, it also allows the other objects on the sheet to be accessed. Is there a way to allow the Edit Objects option in a specified range of cells and still protect the sheet?
Problem 2: I have a sort macro that works fine when the sheet is not protected but will not function (gives runtime error) when sheet is protrected. I have the enable macros checked under sheet protection so macros should be enabled.
Perplexed....
Keyrookie
|