View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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