Forum Discussion
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...
i also sent you a private message.
Alas, the link in your PM doesn't work ("The transfer you requested has been deleted.")
- Sorry about that - not sure why. I attached them to a PM instead.
ExcelFile1.xlsm has a macro named auto_open. This macro will automatically be executed when the workbook is opened.
The auto_open macro refers to a sheet named "form" several times. However, the workbook does not contain such a sheet.
The other workbook does contain a sheet named "form". As far as I can tell, that workbook functions correctly - I was able to display various forms from the startup form. I haven't tested the functionality of those forms though.