| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Links Stopping Workbook_Open Routine
John,
In xl2003 I dont know if you want to update the links or not but this code will stop the links being updated when the workbook is opened. I have not tested the code but if the dialog box is displayed use Application.DisplayAlerts = False. The other constants used can be found in VBA help ActiveWorkbook.UpdateLinks = xlUpdateLinksNever Regards Michael beckinsale |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
| ChangeLinks routine stopped by Update Values dialog | Excel Programming | |||
| Suppress Update Links dialog AND don't update links | Excel Programming | |||
| Excel 2003 - Update or Don't Update Links Problem | Excel Programming | |||
| Stopping the Update Links Message | Excel Programming | |||
Threaded Mode
