how do I get rid of that "security warning" at top of Exel sheet
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 |
how do I get rid of that "security warning" at top of Exel sheet
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--- -- RyGuy "Gerald" wrote: 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 |
how do I get rid of that "security warning" at top of Exel she
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 "ryguy7272" wrote: 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--- -- RyGuy "Gerald" wrote: 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 |
how do I get rid of that "security warning" at top of Exel sheet
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 "Gerald" wrote: 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 |
All times are GMT +1. The time now is 08:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com