Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to protect a column or columns
I have created a worksheet and want to protect several cells or columns so
that they can only be changed by me. However there are other cells or columns that I want accessible to other users. How can this be done or Can it be done? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to protect a column or columns
Highlight the cells you want to be editable by others, go to Format Cells
Protetion and uncheck Locked. Next, go to Tools Protection Protect Sheet to lock out all other cells. Create a password if desired. when you want to edit the locked cells, go to Tools Protection Unprotect Sheet. Make sure to re-protect when you finish. "Clarence" wrote: I have created a worksheet and want to protect several cells or columns so that they can only be changed by me. However there are other cells or columns that I want accessible to other users. How can this be done or Can it be done? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to protect a column or columns
By default all cells in a worksheet are locked when sheet protection is
enabled. It is up to you to decide which are to be locked or unlocked when the sheet is protected. FormatCellsProtection is where you would change the "locked" or "unlocked" status. Select all cells and unlock them. Select the cells to be locked and lock them Then ToolsProtectProtect Sheet.......add a password. Note the selectable options under "allow users to" when protecting, specifically allowing inserting rows. Gord Dibben MS Excel MVP On Wed, 30 Sep 2009 08:56:02 -0700, Clarence wrote: I have created a worksheet and want to protect several cells or columns so that they can only be changed by me. However there are other cells or columns that I want accessible to other users. How can this be done or Can it be done? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect columns with password | Excel Worksheet Functions | |||
Protect Hidden Columns | Excel Discussion (Misc queries) | |||
Can you protect a worksheet from having the columns resized,not ro | Excel Worksheet Functions | |||
Password protect 2 columns | Excel Discussion (Misc queries) | |||
Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) |