Protect just 1 column

[orquidea]

Hi

I want to protect just column c in a spreadsheet. This column has a formula
wich automatically stamps the current date and time. I want to prevent this
formula from been deleted.

Could anyone help me.
Thanks,
Orquidea

 

[Mike H]

By default all cells in a worksheet are protected but this only becomes
active if the worksheet is proected so try this:-

Select all cells and then
Format|Cells|protection and removed the locked checkmark
Then select column C and repeat the above but this time add the checkmark
Protect your sheet and your done.
Caveat this isn't secure

Mike

 

[dlw]

right click on the c column to highlight it, Fromat Cells / Protection / locked
then Tools / protection / protect sheet and give it a password

 

[orquidea]

thanks for your help

right click on the c column to highlight it, Fromat Cells / Protection / locked
then Tools / protection / protect sheet and give it a password

 

[orquidea]

Thanks for your help

By default all cells in a worksheet are protected but this only becomes
active if the worksheet is proected so try this:-

Select all cells and then
Format|Cells|protection and removed the locked checkmark
Then select column C and repeat the above but this time add the checkmark
Protect your sheet and your done.
Caveat this isn't secure

Mike

 

[dp]

Followed this - then wanted to see if I could get around it. True it
wouldn't let me make a change without a password but I was able to copy the
sheet and paste in a new sheet then make a change. I am using excel 2000 -
is the 'protection' feature in 2000 inferior to later years? ps I am just
learning excel

thanks
dp

 

[Gord Dibben]

Protect the workbook for structure then users will not be able to insert a new
worksheet or delete the current protected sheet.

Although they could copy the cells, paste in a new workbook, delete your
workbook, rename their copy as your workbook and then what would you do?

Workbook and sheet protection has not been "upgraded" in newer versions.

Note: Excel internal security is very weak and passwords easily cracked.


Gord Dibben MS Excel MVP

 

[dp]

Thanks for taking the time to respond.

Protect the workbook for structure then users will not be able to insert a new
worksheet or delete the current protected sheet.

Although they could copy the cells, paste in a new workbook, delete your
workbook, rename their copy as your workbook and then what would you do?

Workbook and sheet protection has not been "upgraded" in newer versions.

Note: Excel internal security is very weak and passwords easily cracked.


Gord Dibben MS Excel MVP