how do I get rid of that "security warning" at top of Exel sheet

[Gerald]

how do I get stop that "security warning" ribbon at top of Exel sheet from
appearing every time I open Excel? I have tried to see if there is something
that I need to do but can't find it.

Vista, Office 2007, IE, WinMail

 

[ryguy7272]

Not a whole lot to go on here, so I'm going to make a guess...as far as I
know, you need code to do what you want to do:

Sub Macro1()
Application.DisplayAlerts = False
'etc., etc., etc., etc., etc.,
Application.DisplayAlerts = True
End Sub


Regards,
Ryan---

 

[Gerald]

I haven't learned how to do/edit macros yet. So I clicked on the options and
in that ribbon and did something...can't recall what it was....so I will see
what happens.
thanks for your time

 

[Shane Devenshire]

Hi,

To suppress the display of the security warning bar for macros choose the
following command:
Office Button, Excel Options, Trust Center, Trust Center Settings, Macro
Settings, Enable all macros.

You can also choose to not display the warning bar at all after the above
step by clicking Message Bar tab and turning Never show information about
blocked content on. Then click OK a bunch of times.

If this helps, please click the Yes button

Cheers,
Shane Devenshire