Enabling macro question can be ignored by mistake

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

We have Macros in our excel worksheets. In Excel 2003 when opening an excel
worksheet with VBA code you could set it to ask on opening if the macros
should be enabled or not and the question had to be answered before
continuing, however with Excel 2007 you are asked but in a much more discreet
way in the form of the message bar. If you happen not to see the security
question or forget about it you could end up working on an excel worksheet
where the macros are not running. Is there anyway to get Excel 2007 to ask
the question about enabling macros without the user continuing until the
question has been answered?
 
Mark

There is no way to use the old dialog, but if you put these workbooks in a
location marked as trusted via Office button>Excel options>Trust centre, it
will just work without warning. Alternatively, you can sign them and then
'trust' the 'publisher'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html
 
Nick
I have already tried self certifying myself and adding the certificate to
our Excel template however we have hundreds of other Excel files already
created so unfortunately we need another way. The suggestion about having the
workbooks in a particular trusted location sounds ideal. I’m assuming this
would be a trusted folder, With the Excel files located with in this folder
being automatically trusted? If this is the case could you take me through
the steps required? I have already been into Excel>Office Button> Excel
Options> Trust Centre, option but don’t see how I can add a particular folder
to the trust centre.
 
I have already been into Excel>Office Button> Excel Options> Trust Centre

Excel>Office Button> Excel Options> Trust Center> Trust Center Settings>
Trusted Locations

--
Jim
| Nick
| I have already tried self certifying myself and adding the certificate to
| our Excel template however we have hundreds of other Excel files already
| created so unfortunately we need another way. The suggestion about having
the
| workbooks in a particular trusted location sounds ideal. I'm assuming this
| would be a trusted folder, With the Excel files located with in this
folder
| being automatically trusted? If this is the case could you take me through
| the steps required? I have already been into Excel>Office Button> Excel
| Options> Trust Centre, option but don't see how I can add a particular
folder
| to the trust centre.
|
| "Nick Hodge" wrote:
|
| > Mark
| >
| > There is no way to use the old dialog, but if you put these workbooks in
a
| > location marked as trusted via Office button>Excel options>Trust centre,
it
| > will just work without warning. Alternatively, you can sign them and
then
| > 'trust' the 'publisher'
| >
| > --
| > HTH
| > Nick Hodge
| > Microsoft MVP - Excel
| > Southampton, England
| > (e-mail address removed)
| > web: www.nickhodge.co.uk
| >
| > UK Excel User Conference In Cambridge
| > November 28th - December 1st 2007
| > Register Now @ http://www.exceluserconference.com/UKEUC.html
| >
| >
| >
| > | > > We have Macros in our excel worksheets. In Excel 2003 when opening an
| > > excel
| > > worksheet with VBA code you could set it to ask on opening if the
macros
| > > should be enabled or not and the question had to be answered before
| > > continuing, however with Excel 2007 you are asked but in a much more
| > > discreet
| > > way in the form of the message bar. If you happen not to see the
security
| > > question or forget about it you could end up working on an excel
worksheet
| > > where the macros are not running. Is there anyway to get Excel 2007 to
ask
| > > the question about enabling macros without the user continuing until
the
| > > question has been answered?
| >
| >
 
Back
Top