VBA for XL97

Hello All,

I'm working with an XL07 workbook that includes VBA and macros. I'm using a
module to protect all of the sh in the workbook in ThisWorkbook on _Open,
_NewSheet, and _Close events. Also, some macros within specific sheets use
the module ProtectSheets() to ensure that the calculations within the sh are
not exposed when the macro is run.

The problem that I'm having is that the VBA "password" is visible to the
client upon opening VBEditor. I've tried protecting the "project properties"
with a password in VBEditor and enabling the "Lock project for viewing"
option, but then the client cannot save the workbook.

The MsgBox error that displays for the client is "You cannot save to this
file format when the VBA project is protected. You may unprotect the VBA
project by choosing the Properties command on the Visual Basic Editor's Tools
menu, and entering the password for the active project."

I have looked at the option in Project Properties for Conditional
Compilation Arguments, but I cannot figure out if this is how to approach
this issue. Also, I have to set the option for "Lock project for viewing" to
hide the code containing the actual password for the workbook / worksheets.

Please assist as you are able or help direct me to the most appropriate
resource to resolve this issue.

I can provide code if my post is not clear enough.

Many thanks!

All,

I apologize by posting here twice...new format for me....Subject: VBA
Project Properties for duplicate post.

"dipitiduda" wrote:

> Hello All,
>
> I'm working with an XL07 workbook that includes VBA and macros. I'm using a
> module to protect all of the sh in the workbook in ThisWorkbook on _Open,
> _NewSheet, and _Close events. Also, some macros within specific sheets use
> the module ProtectSheets() to ensure that the calculations within the sh are
> not exposed when the macro is run.
>
> The problem that I'm having is that the VBA "password" is visible to the
> client upon opening VBEditor. I've tried protecting the "project properties"
> with a password in VBEditor and enabling the "Lock project for viewing"
> option, but then the client cannot save the workbook.
>
> The MsgBox error that displays for the client is "You cannot save to this
> file format when the VBA project is protected. You may unprotect the VBA
> project by choosing the Properties command on the Visual Basic Editor's Tools
> menu, and entering the password for the active project."
>
> I have looked at the option in Project Properties for Conditional
> Compilation Arguments, but I cannot figure out if this is how to approach
> this issue. Also, I have to set the option for "Lock project for viewing" to
> hide the code containing the actual password for the workbook / worksheets.
>
> Please assist as you are able or help direct me to the most appropriate
> resource to resolve this issue.
>
> I can provide code if my post is not clear enough.
>
> Many thanks!