ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protecting Checkbox etc. (https://www.excelbanter.com/excel-discussion-misc-queries/155533-protecting-checkbox-etc.html)

Heepo

Protecting Checkbox etc.
 
How can I protect a worksheet in a way that the user can use the checkboxes I
have made but can't delete them?

I have now tried to use the protection function with leaving certain cells
that I want available for user, but this disables the checkboxes. I can't
find a way to protect the worksheet with still enabling the use of the
checkboxes. I'm using the Excel 2003.

Dave Peterson

Protecting Checkbox etc.
 
How about unlocking the cell links associated with the checkboxes, then protect
the worksheet?

Heepo wrote:

How can I protect a worksheet in a way that the user can use the checkboxes I
have made but can't delete them?

I have now tried to use the protection function with leaving certain cells
that I want available for user, but this disables the checkboxes. I can't
find a way to protect the worksheet with still enabling the use of the
checkboxes. I'm using the Excel 2003.


--

Dave Peterson


All times are GMT +1. The time now is 08:30 PM.

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