Unlocking VBA projects

R

Rusty

I'm trying to open an Excel VBA project that was created and password
protected under Windows.

I have the password, but am not prompted for it when I attempt to open
the Excel VBA project for editing. I receive the "Project Locked -
Project is unviewable message"

How can I open a dialog box to unlock the project?

Clicking Tools->VBAProject Properties yields the same message.

Thanks
Rusty
 
E

Edwin Tam (MS MVP)

The project was probably created and locked with Excel 2000 for Windows
You need to ask someone who has Excel 2000 for Windows, and unlock it on his machine, and bring it back to your Macintosh

This problem does not only affect the Mac. If you open the same file in Excel 97 for Windows, you'll see the same result

Regards
Edwin Ta
[email protected]
 
Top