Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Intervention Required When Opening Workbooks
Hi,
We're writing a macro that opens a number of workbooks and creates links to their cells in a master data sheet, and then closes them. The issue arises when the sheet we are opening contains links to external sheets. The "This workbook contains one or more links that cannot be updated." "Continue" or "Edit Links" dialog box comes up. At this point the user has to click Continue for the macro to keep functioning. Naturally this defeats the purpose of the macro, does anyone know the way around this ? Thanks, Rob. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Intervention Required When Opening Workbooks
try the line
application.displayalerts = false ...... code here application.displayalerts = true -- When you lose your mind, you free your life. "Rob Fernando" wrote: Hi, We're writing a macro that opens a number of workbooks and creates links to their cells in a master data sheet, and then closes them. The issue arises when the sheet we are opening contains links to external sheets. The "This workbook contains one or more links that cannot be updated." "Continue" or "Edit Links" dialog box comes up. At this point the user has to click Continue for the macro to keep functioning. Naturally this defeats the purpose of the macro, does anyone know the way around this ? Thanks, Rob. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Oracle without user intervention | Excel Discussion (Misc queries) | |||
User Input Required | Excel Worksheet Functions | |||
Example User Form Required | Excel Discussion (Misc queries) | |||
Exiting a VBA Macro by user intervention | Excel Programming | |||
make sure macro be loaded without user intervention | Excel Programming |