I don't know how you protect your workbook, but a simple password id
definitle not enough.
There are several site on Internet were you can pick-up a Add-In which can
"recover forgotten passwords" (or break them if you are not supposed to know
them).
See www.strax.com/excel/password.html .



"Joe Bannister" schreef in bericht
...
Hello all,

I have a button to which is assigned the following code:

ActiveWorkbook.Save

Now i also need to protect my vba from user sight because
it contains passwords,so this is protected with a
password.

Now when i click the button to save i get a message
saying that this cannot be done with protected vba.

Is there some vba that could be added to the above to
allow the file to be saved but to maintain protection of
the programming?

Some passwords have been discovered when debug errors
expose the programming, and when people have been
medling, i need to stop this.

Very grateful of any help

Cheers

Joe