Excel 2002 "Protect Sheet", but Allow "Insert Comments"?
When using MS Excel 2002: I have turned on "Protect Sheet" to protect some
formulas from being deleted. Prior to turning on protection I unlocked the cells that I wanted users to be able to edit. And I have checked the box to "Allow all users of this worksheet to:" "Select Locked Cells; Select Unlocked Cells; Format cells; ". What I *don't* see on the "Protect Sheet" menu is an option to "Allow all users of this worksheet to: INSERT COMMENTS into unlocked cells. Do you know of any way that I can allow users to do this, without turning off the protection in MS Excel 2002? |
Check the "Edit Objects" button.
VP Safe wrote: When using MS Excel 2002: I have turned on "Protect Sheet" to protect some formulas from being deleted. Prior to turning on protection I unlocked the cells that I wanted users to be able to edit. And I have checked the box to "Allow all users of this worksheet to:" "Select Locked Cells; Select Unlocked Cells; Format cells; ". What I *don't* see on the "Protect Sheet" menu is an option to "Allow all users of this worksheet to: INSERT COMMENTS into unlocked cells. Do you know of any way that I can allow users to do this, without turning off the protection in MS Excel 2002? -- Dave Peterson |
Thanks - your answer to this question worked also! Thank you so much!
"VP Safe" wrote: When using MS Excel 2002: I have turned on "Protect Sheet" to protect some formulas from being deleted. Prior to turning on protection I unlocked the cells that I wanted users to be able to edit. And I have checked the box to "Allow all users of this worksheet to:" "Select Locked Cells; Select Unlocked Cells; Format cells; ". What I *don't* see on the "Protect Sheet" menu is an option to "Allow all users of this worksheet to: INSERT COMMENTS into unlocked cells. Do you know of any way that I can allow users to do this, without turning off the protection in MS Excel 2002? |
All times are GMT +1. The time now is 04:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com