Security for a column within a sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top