ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Locked & protected cells still can be changed (https://www.excelbanter.com/excel-worksheet-functions/53585-locked-protected-cells-still-can-changed.html)

Amenity Dana

Locked & protected cells still can be changed
 
I have a worksheet set up with several columns, five of which are formulas
calculating date put into other columns. I want to protect those 5 specific
columns of cells so that the formulas cannot be changed. I selected each
cell and tagged it "locked" and I protected the worksheet. Then I went back
to verify that it did in fact lock each of the formulas. Three of the
columns of cells cannot be changed and are read-only. Two of them let me
change the formulas as if the cells are not locked. I have double checked
the protection on them, and everything is as the instructions specify. Any
ideas of what else I should look for?

Thanks,
Dana Cline


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

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