Enabling macro question can be ignored by mistake

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 03 Dec 2007 15:20 GMT

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?

Reply to this Message

Nick Hodge - 03 Dec 2007 19:13 GMT

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'

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
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
[quoted text clipped - 7 lines]
> the question about enabling macros without the user continuing until the
> question has been answered?

Reply to this Message

Mark - 04 Dec 2007 14:44 GMT

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.

> Mark
>
[quoted text clipped - 14 lines]
> > the question about enabling macros without the user continuing until the
> > question has been answered?

Reply to this Message

Jim Rech - 04 Dec 2007 17:01 GMT

>>I have already been into Excel>Office Button> Excel Options> Trust Centre

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

Signature

Jim

| Nick
| I have already tried self certifying myself and adding the certificate to
[quoted text clipped - 5 lines]
| 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.
|
[quoted text clipped - 16 lines]
| > > the question about enabling macros without the user continuing until the
| > > question has been answered?

Reply to this Message