Macro Settings in Excel2007

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

Simon Lloyd

Ted you need to have the macros digitally signed or trust him as a
publisher.
Ted said:
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.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top