View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul B[_8_] Paul B[_8_] is offline
external usenet poster
 
Posts: 20
Default Protect or Lock Column

Tom,
By default all cells in excel are protected or locked, select the cells you
want to unlock and go to format, cells, protection and uncheck locked, the
go to tools, protection, and protect sheet, enter a password if you want,
now only the cells that you unlocked can be edited.



If you only need a few locked I would select them all first, Ctrl A, then
go to format, cells, protection and uncheck locked, then select the cells
you want to lock and go to format cells and check locked, the go to tools,
protection, and protect sheet, enter a password if you want, now the cells
that you locked can not be edited
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **


"Tom LeBold" <Tom wrote in message
...
In Microsoft Access I have locked or disabled controls or columns to
prevent
the user from changing the data displayed in the column.
Is it possible to lock, protect or disable a column in Excel?
I don't want the user to be able to enter data in column A.