View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frederick Chow Frederick Chow is offline
external usenet poster
 
Posts: 75
Default 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