Enabling Macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Gregg - 25 Sep 2007 14:12 GMT

I have been trying to enable macros in Excel 2007 (recently acquired) and
though I have turned on Enable Macros and VB etc. It will still not let me
use them and I continue to get the security warning when the file is opened.
Can anyone give me an answer

Reply to this Message

Bob Phillips - 25 Sep 2007 16:31 GMT

Are you opening files from a previous version? If so, and there is a button
above the spreadsheet about security (forget the exact text) click that and
see if they are now enabled.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have been trying to enable macros in Excel 2007 (recently acquired) and
> though I have turned on Enable Macros and VB etc. It will still not let me
> use them and I continue to get the security warning when the file is
> opened.
> Can anyone give me an answer

Reply to this Message

Brian Gregg - 25 Sep 2007 17:42 GMT

Yes I am opening files from Excel 2003

Do you mean the words along the lines of: Security macros disabled. If yes,
then
I do what is suggested and select the enable option, but it still comes up
with the warning.

> Are you opening files from a previous version? If so, and there is a button
> above the spreadsheet about security (forget the exact text) click that and
[quoted text clipped - 5 lines]
> > opened.
> > Can anyone give me an answer

Reply to this Message

Bob Phillips - 25 Sep 2007 18:32 GMT

Yes that's the one. Fid you look at the security options, it says 'Disable
all macros with notification'. I think this means that this is what happens.

When you select Enable, the macros work, right?

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Yes I am opening files from Excel 2003
>
[quoted text clipped - 17 lines]
>> > opened.
>> > Can anyone give me an answer

Reply to this Message

Rate this thread: