Enable Macro Alert Box

[Mattlynn via OfficeKB.com]

Hi.
Is there a way, you can turn off the warning regarding macros when you opena
file that contaons one.

I know the file has macros in it as i created it, but is there a way to get
excel to stop forever telling me and giving me 3 options everytime i open the
file such as diable, enable, and more info.

Is there a way to turn this feature off full stop.

Many Thanks for your help as always all.
MattLynn

 

[Ashish Mathur]

Hi,

Tools > Options > Security > Macro Security > Low

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Ms-Exl-Learner]

Tools>>Macro>>Security>>Security Level and set it as Low.

If this post helps, Click Yes!

 

[Mattlynn via OfficeKB.com]

Brilliant - Thanks.
I guessed it was something easy like that
Many Thanks again
Regards
Matt

Hi,

Tools > Options > Security > Macro Security > Low

Hi.
Is there a way, you can turn off the warning regarding macros when you

[quoted text clipped - 11 lines]

Many Thanks for your help as always all.
MattLynn

 

[Mattlynn via OfficeKB.com]

Brilliant - Thanks.
I guessed it was something easy like that
Many Thanks again
Regards
Matt

Tools>>Macro>>Security>>Security Level and set it as Low.

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------

Hi.
Is there a way, you can turn off the warning regarding macros when you opena

[quoted text clipped - 8 lines]

Many Thanks for your help as always all.
MattLynn

 

[Gord Dibben]

If just for your own use have a look at creating a digital signature using
the MS Office selfcert tool.

Sign your book and get rid of the message without compromising security.


Gord Dibben MS Excel MVP

 

[JP]

Agreed with Gord on this one, lowering your security is a bad idea,
you might forget and then open another macro-enabled workbook that
could damage your computer and you would have no way to stop it. A
digital signature for your personal projects is a better idea.

--JP

 

[Ashish Mathur]

You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Mattlynn via OfficeKB.com]

Thanks Gordon - that seems like an interesting way round the problem.
I shall check this out too.
Many Thank for helpingRegards
Matt

If just for your own use have a look at creating a digital signature using
the MS Office selfcert tool.

Sign your book and get rid of the message without compromising security.

Gord Dibben MS Excel MVP

Hi.
Is there a way, you can turn off the warning regarding macros when you opena

[quoted text clipped - 8 lines]

Many Thanks for your help as always all.
MattLynn

 

[Mattlynn via OfficeKB.com]

Thanks Gordon - that seems like an interesting way round the problem.
I shall check this out too.
Many Thank for helpingRegards
Matt

If just for your own use have a look at creating a digital signature using
the MS Office selfcert tool.

Sign your book and get rid of the message without compromising security.

Gord Dibben MS Excel MVP

Hi.
Is there a way, you can turn off the warning regarding macros when you opena

[quoted text clipped - 8 lines]

Many Thanks for your help as always all.
MattLynn