Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect just 1 column
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect just 1 column
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 "orquidea" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect just 1 column
right click on the c column to highlight it, Fromat Cells / Protection / locked
then Tools / protection / protect sheet and give it a password "orquidea" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect just 1 column
thanks for your help
"dlw" wrote: right click on the c column to highlight it, Fromat Cells / Protection / locked then Tools / protection / protect sheet and give it a password "orquidea" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect just 1 column
Thanks for your help
"Mike H" wrote: 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 "orquidea" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect just 1 column
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 "Mike H" wrote: 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 "orquidea" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect just 1 column
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 On Tue, 10 Jun 2008 08:13:00 -0700, dp wrote: 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 "Mike H" wrote: 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 "orquidea" wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect just 1 column
Thanks for taking the time to respond.
"Gord Dibben" wrote: 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 On Tue, 10 Jun 2008 08:13:00 -0700, dp wrote: 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 "Mike H" wrote: 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 "orquidea" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to protect a column in a spreadsheet | Excel Worksheet Functions | |||
Protect Autofiler Column | Excel Discussion (Misc queries) | |||
Protect column | Excel Discussion (Misc queries) | |||
how do I protect just 1 column. | Excel Discussion (Misc queries) | |||
How to protect a column? | Excel Discussion (Misc queries) |