Workbook_BeforeSave: Bypassing prompts for external links

[Frederick Chow]

Hi all,

I am trying to writing a Workbook_BeforeSave event procedure to handle files
with external links. However, Excel's own prompt (Save "Bookx" with
reference to unsaved documents?) always pre-empts the event procedure
whenever external links exist in the workbook to be saved.

I want to know if there are ways to intercept such prompt in the BeforeSave
event procedure. Thanks a lot.

Frederick Chow
Hong Kong

 

[Henrich]

Hi, you don't want to be prompt to save the files? If yes then:

'your code
Application.DisplayAlerts = False
'your code

Henrich

„Frederick Chow" napísal (napísala):