Not Update some Links at FileOpen

pilot

Active Member
Joined
Feb 17, 2002
Messages
345
Every time I open my wb I get a message (as expected) saying that one or more links could not be be updated. Does code in the Workbook_Open event run before such messages are generated?

I'd like to accomplish the following with code (in order of preference):

1) Avoid this error being displayed if the cause is "Source not found", or cause the equivalent of the "Continue" button being pressed. If I can't specify the cause, then just avoid the error being displayed at FileOpen.

2) Define the attribute of individual (or groups of) links such that they are not updated at File_Open.

I do want to update all other links at open.
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,118,726
Messages
5,573,837
Members
412,552
Latest member
sfay
Top