VBA Password problem in excel 97

  • Thread starter Thread starter RANDY IN NC
  • Start date Start date
R

RANDY IN NC

I have a Vba Project written in excel 2000. the properties are protected
and locked... I works fine in 2000 and later, when you try to enter it
asks for the password... then lets you in upon entry of that password..


but in excel 97 it just says it is locked from viewing.. I have tried
unchecking the locked from viewing box and leaving the password... but
it still gives me the same...

Is the a solution that would make it work as it does in 2000.

Thank you Randy
 
Hi Randy

Unlock your VBA in 2000 (uncheck protection in tools>properties) and save

Open in 97
Protect your VBA in Excel 97 and save

You can now unlock it in every version
 
You must log in or register to reply here.

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

Save as problem for Excel 97/2000 (with VBA-protection in excel 20 3
Cannot view code in VBE of a file with no password protection 3
excel 97, VB project unable to view in another comp 2
VBA Project Password Changed on its own?!?! 0
Locking the VBA Project 13
Excel VBA Project Has Protection? 2
Controlling worksheet protection via VBA 0
hard code a password in a vba code 2

Back
Top