Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppressing links message
I am using Excel 97 and wonder whether there is any code I
can use to suppress the links to other spreadsheets message. Thanks Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppressing links message
Something like this...
Sub Macro1() Application.DisplayAlerts = False Workbooks.Open Filename:="C:\My Documents\My Excel Files\Bloomberg\fx.xls", _ UpdateLinks:=3 Application.DisplayAlerts = True End Sub Robin Hammond www.enhanceddatasystems.com "Mark" wrote in message ... I am using Excel 97 and wonder whether there is any code I can use to suppress the links to other spreadsheets message. Thanks Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppressing links message
Robin gave you some code that you could use if you are opening a workbook
programmatically. If you mean when you open it manually, there is not way to do that if you don't want the links updated. If you want to allow the links to be updated, you can remove the check in the Options dialog (tools=Options=Edit tab) for Ask to Update Automatic links. This question is asked prior to any macros running and there is no setting which removes the prompt (in Excel 97. In Excel 2002, they added a setting under the Edit=Links menu). -- Regards, Tom Ogilvy "Mark" wrote in message ... I am using Excel 97 and wonder whether there is any code I can use to suppress the links to other spreadsheets message. Thanks Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to avoid the pop up message for updating links? | Excel Discussion (Misc queries) | |||
Message on startup shows that links are present | Excel Discussion (Misc queries) | |||
Suppress Update Links Message | Excel Discussion (Misc queries) | |||
broken links message still popping up | Excel Discussion (Misc queries) | |||
Disabling the Update links message | Excel Programming |