Unlocking VBA projects

Posted: 12-01-2003, 08:28 PM

Rusty

Guest
Posts: n/a

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

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

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

LinkBack

Thread Tools

Display Modes

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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