This has just started happening

[colinharwood]

Hi
I have an Excel file which I have been using for many years, and it has just started to be a problem.
When opening the file, please see screenshot 1, this happens, and when closing the file, screenshot 2 happens.
Any idea what can be causing this
Thanks

 

[Joe4]

From the VBA Editor, if you go to Tools --> References, which libraries do you have selected? You should probably have at least these 4 (though they may be different version numbers):

Also, I highly recommend turning on "Option Explicit". This will force you to declare all variables before using them. This is a great way to avoid typos, and any confusion between variables, functions, procedures, objects, etc.
See here: How to use Option Explicit Statement in VBA

 

[RoryA]

You almost certainly have at least one library selected that is shown with 'MISSING:' at the start of its name.

 

[colinharwood]

Thank you guys
I removed the missing entry and all seems well now