T
Ted Mercer
I am struggling to understand macro settings in Excel2007.
I have an Excel application which includes a number of VBA macros written
to perform various operations. The Excel application is opened by another
application written in VB6. I therefore must permit a user to run the VB6+
Excel combination, which appears to him as a single application, without
having to approve the use of the VBA macros included in Excel. I save the
application using the Save As Excel 97-2003 Workbook format so as to
maintain the .xls name extension since it also now runs in those versions.
The Trust Center Macro Settings has 4 options but only the "Enable all
macros" option seems to fulfill this need, unless the documents are in a
trusted location. This option is not recommended by Excel and I am searching
for an alternative the would disable all other macros except those in my VBA
module. I am reluctant to have to direct users to specifically create a
trusted location in which to install the application. I do not have this
complication with the earlier versions of Excel.
The Trust Center Developer Macro Settings has an option which says: "Trust
access to the VBA project object model". This is discussed in Excel Help but
I do not understand the explanation. Is it saying that if the Developer
option is selected I will have the desired security ? If it is selected ,
which of the 4 previous options, if any, should I also select?
Thanks for helping.
I have an Excel application which includes a number of VBA macros written
to perform various operations. The Excel application is opened by another
application written in VB6. I therefore must permit a user to run the VB6+
Excel combination, which appears to him as a single application, without
having to approve the use of the VBA macros included in Excel. I save the
application using the Save As Excel 97-2003 Workbook format so as to
maintain the .xls name extension since it also now runs in those versions.
The Trust Center Macro Settings has 4 options but only the "Enable all
macros" option seems to fulfill this need, unless the documents are in a
trusted location. This option is not recommended by Excel and I am searching
for an alternative the would disable all other macros except those in my VBA
module. I am reluctant to have to direct users to specifically create a
trusted location in which to install the application. I do not have this
complication with the earlier versions of Excel.
The Trust Center Developer Macro Settings has an option which says: "Trust
access to the VBA project object model". This is discussed in Excel Help but
I do not understand the explanation. Is it saying that if the Developer
option is selected I will have the desired security ? If it is selected ,
which of the 4 previous options, if any, should I also select?
Thanks for helping.