ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protect Cells (https://www.excelbanter.com/excel-discussion-misc-queries/218898-protect-cells.html)

Carl R[_3_]

Protect Cells
 
Issue:
I would like to protect specific columns in a spreadsheet, but still allow
grouping, and hide column and all other functions on non-protected and
protected cells.

In other words, I want to prevent the modification of the data in these
cells, but all other functionality be the same.

Action taken:
I have locked the specific cells with the format command and tools- protect
worksheet, with all options checked except select locked cells.

Any advise?


All times are GMT +1. The time now is 06:33 PM.

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