Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA for XL97
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LEN function in XL97 | Excel Discussion (Misc queries) | |||
Web Query Failure using url.CFM with xl97 | Excel Programming | |||
XL97 - Command Bar Removal | Excel Programming | |||
Problems with xl97 & xl2K | Excel Programming | |||
UDF returns #value in XL97 | Excel Programming |