Password the VB Editor

M

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
 
P

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 **
 
P

Peo Sjoblom

The password was there for a reason

--


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

Regards,

Peo Sjoblom

Sarah J said:
If the VBA project password is unknown, how do you take off the password
Click to expand...
if you want to use the user-defined functions in another workbook?
 
J

JE McGimpsey

Sarah J said:
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.
Click to expand...

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