All Internal Passwords.xls Error 91

D

Dennis

As with Nathan below, I ran this code on Office XP (XL)
with XP Pro and received the same error.

I loaded ONLY allinternalpasswords.xls and ran the Macro.

Does another W/S have to be loaded? How does one apply
this macro to a specific sheet?

As Nathan Gutman & myself found:

When trying to run it it gets to line:

WinTag = .ProtectStructure Or .ProtectWindows

and gives runtime error 91

Object variable or With block variable not set.

Can someone help to undertand why and how to fix that?
 
C

Chip Pearson

Dennis,

You should open the workbook whose passwords you want to break.
This should be the active workbook when you execute the
AllInternalsPassword macro.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
N

Norman Harker

Hi Dennis!

Just tested on the same setup and there doesn't appear to be any
problems.

With the protected book active:

Tools > Macro > Macros
Select All Open Workbooks (if not already selected)
Select AllInternalPasswords
Run

Press OK as and when

All internal passwords are removed.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top