It's a normal workbook.
I'm using Excel 2002 on Windows XP Pro Version 2002.

-----Original Message-----
Just curious. What's the format of your workbook?

Is it a normal workbook or saved in some previous
version or other program's
format?

Joe Bannister wrote:

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

--

Dave Peterson

.