I have a bunch of links which link to files named EX1 to EX10. I have a master file which summarises these 10 files (which contain timesheets). This master file complains when one of these EX files is missing (and they will almost always be a few missing.

What I want to do is get rid of the 'could not update links' error that pops up when opening the workbook. I already have macros running in the workbook so all I need to know is what to disable and where to disabled and re-enable it once the error has been bypassed.

However I have macros running which use thisworkbook - workbook_beforeclose, workbook_open, workbook_deactivate, workbook_beforesave and workbook_open so I cant disable anything that would prevent these macros running (they force users to enable macros by showing a dummy sheet and hiding all the others if macros are disabled).

Thanks