I have a workbook within which there are links to a number of other workbooks. Ideally I'd like code that, when I open the workbook containing the links, will update the links but only if the workbook that is being linked to is not open (either on my PC or one of the other users on the network that can access it). This is because: a) if the workbook is already open the link should update anyway, b) updating links to workbooks that are already open seems to cause errors.

I hope I'm making sense, please tell me if I'm not. Thanks.