View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_5_] Nigel[_5_] is offline
external usenet poster
 
Posts: 42
Default 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 =---