View Single Post
  #2   Report Post  
GerryK
 
Posts: n/a
Default Protected sheet to unprotected sheet

You could try to highlight the whole sheet (top left corner), copy and paste
to a blank sheet or new workbook.

HTH
GerryK

" wrote:

I have a worksheet in Excel 2002 which is protected (as is the
workbook) and the person that protected it is not with our company
anymore. I need change the worksheet to update it and would just like
to copy it to a new one, but cannot figure out how to copy it without
copying the protection. Any help would be appreciated.

Michael