View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peter Peter is offline
external usenet poster
 
Posts: 349
Default How unlock locked cells

In 2003, you have to go to TOOLS and then PROTECTION to globally turn on or
off the capability, and then go the FORMAT CELLS and the PROTECTION tab to
deal with the settings of individual cells.

"Robin" wrote:

I understand how to lock cells; however, I have changed a format and would
like for some of the cells that were locked to become unlocked when the sheet
is protected. How do I unlock these locked cells.

Sincerely,

robin