ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   is there a way to protect a range of cells on a worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/13669-there-way-protect-range-cells-worksheet.html)

vevans

is there a way to protect a range of cells on a worksheet?
 
I am trying to lock several columns in a worksheet that contain formulas that
I do not want to be able to accidentally change. Is there a way to do this,
or can I only protect the entire worksheet?


Peo Sjoblom

Select the whole worksheet, do formatcellsprotection, uncheck locked, now
select the columns you want to protect,
repeat and select locked, protect the sheet

--

Regards,

Peo Sjoblom

"vevans" wrote in message
...
I am trying to lock several columns in a worksheet that contain formulas

that
I do not want to be able to accidentally change. Is there a way to do

this,
or can I only protect the entire worksheet?





All times are GMT +1. The time now is 03:32 PM.

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