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



Joe Bannister wrote:

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

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

.


--

Dave Peterson