worksheet password protected user forgot password

[Kathy]

Hello,
I have a user that forgot the password she used to
protect a worksheet in a workbook. Any idea besides
recreating the worksheet?
Any help is always appreciated.

 

[Norman Harker]

Hi Kathy!

Take a trip to:
JE McGimpsey
http://www.mcgimpsey.com/excel/removepwords.html


Download the AllInternalPasswords.xls file
Open that File
Open the offending workbook
Tools >Macro > Macros
Select AllInternalPasswords
Run
Follow the easy instructions
Save the file
Done
Remember to buy John McCormick, JE, and me beers when you see us.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Kathy]

Thanks Norman, and yes beers are on me!!

-----Original Message-----
Hi Kathy!

Take a trip to:
JE McGimpsey
http://www.mcgimpsey.com/excel/removepwords.html


Download the AllInternalPasswords.xls file
Open that File
Open the offending workbook
Tools >Macro > Macros
Select AllInternalPasswords
Run
Follow the easy instructions
Save the file
Done
Remember to buy John McCormick, JE, and me beers when you see us.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.

 

[Ron de Bruin]

Remember to buy John McCormick, JE, and me beers when you see us

You are always drunk then Norman<g>

 

[Norman Harker]

Hi JE!

Probably true. JE reports that he gets very heavy downloads of that
particular code.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.