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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Hide columns based on row values 2
macro to sum select columns in all workseets within a workbook 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Comparing columns with repeating data 3
Help with Macro for sorting 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
finding duplicate addresses across 2 worksheets in the same workbo 2

Back
Top