Excel files with macros/VB failing

In my organisation we use two files which contain macros. Both were written 5 or 10 years ago and have always worked with no issues but recently they work for a period of time and then we get error m...