View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I lock a cell in excel file ?

the default setting for cells is locked. However, this is not enforced
until the worksheet is protected. Have you unlocked the cells that you want
the user to have access to, then protected the sheet?

--
Regards,
Tom Ogilvy


<Raja; "London" <Raja, wrote in message
...
Hi,
I want to lock few cells which carries formulae, so that data entry person
do not make any changes. He or she only enters the data.