View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Muhammed Rafeek M Muhammed Rafeek M is offline
external usenet poster
 
Posts: 179
Default Unprotect a range of cells in a protected worksheet

Step1: Before protecting select a range,
Step2: Format - Cell - Protection tab
Step3: Unselect "Locked" and click "OK"
Now you can Protect worksheet


Please do rate

"N.B.Pitkar" wrote:

I have MS office 2000. How can I unprotect a range of cells in a protected
worksheet?