Saving while vba is passworded

J

Joe Bannister

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
 
J

Jim Rech

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

| 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
|
 
D

Dave Peterson

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?
 
G

Gerrit van Stempvoort

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 .
 
J

Joe Bannister

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

Joe Bannister

Well now, it seems to work if i'm using and saving as
Microsoft Excel Workbook(*.xls), but does not work if
using and saving as Microsoft Excel 5.0/95 Workbook
(*.xls) or Microsoft Excel 97-2002 & 5.0/95 Workbook
(*.xls)!
Do you know the reason for this?

Cheers

Joe
 
D

Dave Peterson

xl97 was the first version to provide the VBE (and offer protection in the VBE).

xl95 had codesheets with no protection (IIRC). (I think hiding the codesheets
was as good as you could get.)
 
Top