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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active Content in this file is blocked issue 1
Project is unviewable 2
unlocking VBA project programatically 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA Code not shown 3
VB Project locked 1
Excel for Mac 2004 Project locked and unviewable 1
Cannot view code in VBE of a file with no password protection 3

Top