Workbook_BeforeSave: Bypassing prompts for external links
 

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

Workbook_BeforeSave: Bypassing prompts for external links
 

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):

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