Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I protect just 1 column.
I have a spread sheet that I need to protect just on column. The person with
the password will be able to enter data in that column. Is there a way for me to this? |
#2
|
|||
|
|||
how do I protect just 1 column.
Highlight the column, Select Format, Protection and check Locked. You may have to select the entire worksheet first and unlock all the cells. The Porotect the Worksheet and allow users to selct unlocked cells. carol Wrote: I have a spread sheet that I need to protect just on column. The person with the password will be able to enter data in that column. Is there a way for me to this? -- jahoobob |
#3
|
|||
|
|||
how do I protect just 1 column.
Hi Carol,
All cells have protection turned on by default, but the protection is not effective until the worksheet is protected. select all cells format, cells, protection uncheck the boxes (noting which were checked) select the column to be protected check the boxes originally checked for protection if it look right there are variations depending on version tools, protection, protect sheet I believe you will not be permitted to insert rows anywhere, nor insert columns before the protected column. (didn't bother testing). To unprotect sheet tools, protect, unprotect sheet You can record a macro, turning off protection using a password that you said would be required, making a change, then protecting one more. Something to keep in mind is that password protection is designed to protect data against accidental changes -- it should not be considered as a reliable security mechanism. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "carol" <carol @discussions.microsoft.com wrote in message ... I have a spread sheet that I need to protect just on column. The person with the password will be able to enter data in that column. Is there a way for me to this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) |