Unlocking VBA projects

Posted: 12-01-2003, 08:28 PM
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
Reply With Quote

Responses to "Unlocking VBA projects"

Jason Kelly [MS]
Guest
Posts: n/a
 
Re: Unlocking VBA projects
Posted: 12-02-2003, 11:35 PM
On 12/1/03 1:28 PM, "Rusty" <rusty@vonwaldburg.com> wrote:
> 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"
It's likely that the VBA project was digitally signed on Windows. Mac Excel
doesn't recognize digital signatures in macros, so it can't update the
signature if you modify a signed VBA macro. Therefore, to prevent
modifications, you cannot view the code for macros that have been digitally
signed in Office for Windows.

--
Jason Kelly
Mac Excel Testing - Microsoft

Reply With Quote
Edwin Tam (MS MVP)
Guest
Posts: n/a
 
RE: Unlocking VBA projects
Posted: 12-03-2003, 05:11 AM
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
eptools@mac.com
Reply With Quote
 
LinkBack Thread Tools Display Modes
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Similar Threads
Thread Thread Starter Forum Replies Last Post
unlocking computer lmartino Windows Vista Administration 1 11-08-2006 01:38 AM
Unlocking computer's XP Chuck Windows XP Accessibility 0 09-06-2004 04:11 PM
Unlocking comp. Christina Customize Windows XP 0 07-30-2003 09:40 PM
unlocking attachments Miha Pihler Windows XP Security & Administration 2 07-26-2003 03:15 PM
Unlocking Windows Henry Paul Windows XP Basics 3 07-20-2003 07:44 PM