View Single Post
  #1   Report Post  
Keyrookie Keyrookie is offline
Member
 
Posts: 84
Default 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