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 |
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