View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CWillis CWillis is offline
external usenet poster
 
Posts: 36
Default Protected Workbook - Not a Good Idea!

Copy the code from this site:

http://www.mcgimpsey.com/excel/removepwords.html

-Chris

"Karen" wrote:

I have a workbook that I protected so long ago that I cannot remember the
password - Big mistake! I want to do a "Save As" and save it as a different
file name. When I do this, it's still protected. I cannot rename any sheet
tabs or move or copy any of the sheets. What do I do? Am I SOL? HELP!

Any help would be greatly appreciated, Karen