ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Password Protection (https://www.excelbanter.com/excel-discussion-misc-queries/20922-password-protection.html)

JamesD

Password Protection
 
In excel i have locked certain cells in the spreadsheet as they were being
deletd. However, users cannot insert a comment in the unlocked cells. I am
using 2000 professional.

Dave Peterson

In the Tools|protect|protect worksheet dialog, there's a an option to protect
Objects. Make sure you leave that option unchecked.

But this affects all the objects (pictures/buttons/checkboxes, etc), too.

JamesD wrote:

In excel i have locked certain cells in the spreadsheet as they were being
deletd. However, users cannot insert a comment in the unlocked cells. I am
using 2000 professional.


--

Dave Peterson


All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com