As far as I know what you're seeing is not normal Excel behavior. You're
not the first person to report this problem, so I know it's a real issue,
but I've never run into it and I cannot reproduce it. I know this isn't
particularly helpful, but I just wanted to explain why you might not get an
answer.

--
Jim Rech
Excel MVP

"Joe Bannister" wrote in message
...
| 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
|