View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Editing a protected sheet

Hi
- first select this cell before protecting the sheet
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now protect your sheet

-----Original Message-----
Hi All,

My requirement is that users should be able to edit a

cell in a protected
work sheet.

Currently, when a user tries to edit the cell the content

of the cell goes
off.

Any help is appreciated. I am running Excel 2000.

Thanks,
Govind.


.