Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect on column from a workbook
It seem like there is no way to protect only one column from a workbook. I
read all the first page of the q&a but all of them is protect the whole workbook. Is there a way to make a column that not allow the user to edit? I am using excel 2003. Your advice and suggestion or i missed the q&a that i want would be very appreciate. thanks Cheers hoac hen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect on column from a workbook
Each cell can be set to locked or unlocked. (Format|cells|protection tab) And
you can select groups of cells to change all at once. And unless you've done something strange, the default state of the "lockedness" of all the cells is Locked. So you can unlock all the cells by selecting all the cells format|cells|protection tab|uncheck locked. Then select the one column you want to protect format|cells|Protection tab|check locked. But that locked stuff won't do much until you protect the sheet. tools|Protection|protect sheet (give it a memorable password) This password can be broken quite easily--so don't depend on this to stop users from finding stuff you don't want found! And be aware that lots of stuff is disabled if you protect the worksheet. You may want to test it to see if it's too restrictive for your purposes. hoachen wrote: It seem like there is no way to protect only one column from a workbook. I read all the first page of the q&a but all of them is protect the whole workbook. Is there a way to make a column that not allow the user to edit? I am using excel 2003. Your advice and suggestion or i missed the q&a that i want would be very appreciate. thanks Cheers hoac hen -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
mail merging 2 workbooks??? | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
grand total column B from every worksheet in workbook | Excel Discussion (Misc queries) |