I have some VBA & User forms in an Excel Book that were written in 2005, everything has worked fine on every upgrade to Excel and on 365 up until last week.
Upon trying to open the workbook it will not open and when I can eventually get to the debugger it comes up with the attached.
With much fiddling and getting it into safe mode and I disable user form1 it seem to open fine, I can then manually bring up user form1 OK.
My issue is there are hundreds of spreadsheets in use that now won't open, any ideas what may have gone wrong and a fix?
Thanks for your help.