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