Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected Workbook - Not a Good Idea!
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected Workbook - Not a Good Idea!
John McGimpsey has code to strip out internal passwords.
http://www.mcgimpsey.com/excel/removepwords.html Gord Dibben MS Excel MVP On Thu, 6 Jul 2006 08:27:02 -0700, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Autofilter on protected workbook | Excel Discussion (Misc queries) |