ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Security for a column within a sheet (https://www.excelbanter.com/excel-worksheet-functions/160620-security-column-within-sheet.html)

nabanco

Security for a column within a sheet
 
Hello,

Is there a way to secure just one column within a worksheet so that no user
in a shared workbook can edit that column?

Trying to do this without creating a macro if possible.

The column is the B column in this example.

Thank you

Darren Bartrup[_2_]

Security for a column within a sheet
 
I'm not really up on shared workbooks, but could you lock the cells in column
B and unlock all the others - goto Format~Cells and click on the Protection
tab to lock or unlock cells.
Then protect the sheet to enforce the cell protection -
Tools~Protection~Protect Sheet.


All times are GMT +1. The time now is 07:04 AM.

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