Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop getting the "privacy warning" messagein Excel 2007? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
I WOULD LIKE TO CHANGE "." FOR "," IN EXEL FILE, CAN YOU HELP ME? | Excel Discussion (Misc queries) | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) |