View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default How to lock cell

Cannot be done.

Sheet must be protected in order to lock cells.


Gord


On Wed, 14 Mar 2012 07:51:14 +0000, Moideen
wrote:


Spencer101;1599757 Wrote:
Do you mean have one particular cell that cannot be updated/altered but
the rest can?

Or do you mean have a locked cell but without protecting the work sheet?


Yes, I mean have a locked cell but without protecting the work sheet.