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 |
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 |
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 |
All times are GMT +1. The time now is 05:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com