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

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

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

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

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

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

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

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