View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Lock worksheet, but leave one column open

Select that column an then:-

Format|cells|protection and remove the locked checkmark click OK

Then

Tools protection|Protect sheet.

Mike


"slavenp" wrote:

I would like to lock a worksheet down but allow only one column to be
populated.