Locking/Unlocking a VBA Project in 2000 vs '97 - Difference?
 

Don't know whether or not this is the proper place for this, but tried it in
the Word VBA-General NG (same problem whether Word or Excel) and haven't had
any response (I'm not impatient, but I posted it On Oct 28th).

Is there a known problem with locking a VBA project in Office 2000 and
trying to unlock it in Office '97?
(ie (Project/Module) Properies-Protection-"Lock Project for Viewing")

Because I wanted to prevent the user (another organization) from monkeying
around I thought it seemed straightforward enough when I did it on my home
machine (Off 2000). Worked fine, popped up a password dialogue box and
opened it when I supplied the password.

Zipped/Sent the file to work and attempted to modify it on Off '97.
All I get is a "Project is Unviewable" message (no password box - nothing).

I opened it on a 2000 m/c at work and it worked fine.

Is there a secret?

Rob

Locking/Unlocking a VBA Project in 2000 vs '97 - Difference?
 

Rob,

You can't open in 97 projects that are password protected in 2000. You have
to use 2000 or later to open the project. It isn't a problem as such; the
later versions use a different and stronger method of encoding the password
and therefore earlier versions can't open the project.


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



"RobNew" wrote in message
...
Don't know whether or not this is the proper place for this, but tried it
in
the Word VBA-General NG (same problem whether Word or Excel) and haven't
had
any response (I'm not impatient, but I posted it On Oct 28th).

Is there a known problem with locking a VBA project in Office 2000 and
trying to unlock it in Office '97?
(ie (Project/Module) Properies-Protection-"Lock Project for Viewing")

Because I wanted to prevent the user (another organization) from monkeying
around I thought it seemed straightforward enough when I did it on my home
machine (Off 2000). Worked fine, popped up a password dialogue box and
opened it when I supplied the password.

Zipped/Sent the file to work and attempted to modify it on Off '97.
All I get is a "Project is Unviewable" message (no password box -
nothing).

I opened it on a 2000 m/c at work and it worked fine.

Is there a secret?

Rob

Locking/Unlocking a VBA Project in 2000 vs '97 - Difference?
 

Chip;
Thank you very much.
I wasn't sure if it was just me (a little older, a little slower).

Rob

Locking/Unlocking a VBA Project in 2000 vs '97 - Difference?
 

Rob,
I had the exact same problem. Whilst the protection is not backward
compatible, it is forward compatible. I ended up protecting it in Excel97 -
it retains this same protection in Excel 2002.

Cheers
Nigel

"Chip Pearson" wrote in message
...
Rob,

You can't open in 97 projects that are password protected in 2000. You
have
to use 2000 or later to open the project. It isn't a problem as such; the
later versions use a different and stronger method of encoding the
password
and therefore earlier versions can't open the project.


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



"RobNew" wrote in message
...
Don't know whether or not this is the proper place for this, but tried
it
in
the Word VBA-General NG (same problem whether Word or Excel) and haven't
had
any response (I'm not impatient, but I posted it On Oct 28th).

Is there a known problem with locking a VBA project in Office 2000 and
trying to unlock it in Office '97?
(ie (Project/Module) Properies-Protection-"Lock Project for Viewing")

Because I wanted to prevent the user (another organization) from
monkeying
around I thought it seemed straightforward enough when I did it on my
home
machine (Off 2000). Worked fine, popped up a password dialogue box and
opened it when I supplied the password.

Zipped/Sent the file to work and attempted to modify it on Off '97.
All I get is a "Project is Unviewable" message (no password box -
nothing).

I opened it on a 2000 m/c at work and it worked fine.

Is there a secret?

Rob









----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---