Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Links | New Users to Excel | |||
external links | Excel Discussion (Misc queries) | |||
Password Prompts for Links | Excel Discussion (Misc queries) | |||
#Value w external links | Excel Discussion (Misc queries) | |||
External links | Excel Discussion (Misc queries) |