Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
upgraded norton internet security & lost sheet # bar on excel | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
sheet and workbook security | Excel Discussion (Misc queries) | |||
Compare Sheet Cell to Sheet Column | Excel Worksheet Functions |