Password the VB Editor

[Mark Newbie]

I have seen sopme sheets that when you go into the vb editor ask you
for a password straight away - how do you do this ?

Mark

 

[Paul B]

Mark, To protect the VBA project, from your workbook right-click the
workbook's icon and pick View Code. This icon is to the left of the "File"
menu this will open the VBA editor, in the left hand window right click on
your workbook name and select VBA project properties, protection, check lock
project for viewing and set a password. Press Alt and Q to close this window
and go back to your workbook and save and close the file
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[Peo Sjoblom]

The password was there for a reason

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

If the VBA project password is unknown, how do you take off the password

if you want to use the user-defined functions in another workbook?

 

[JE McGimpsey]

Sure, I understand that. However, the creator is no longer with us. If I
could replicate and move the entire file without looking at or altering the
hidden script, that would be great.

You can find relative inexpensive commercial crackers doing a Google
search.

 

[Guest]

Thanks! I tried a free one with no luck. Maybe money will make the file talk!

 

[timatey]

Hi,
I recommend you to use Password recovery for VBA modules (macros) in
Word and Excel documents http://lastbit.com/vba
Best regards, Tim