Hi i have a pretty lengthy routine that is doing funny things to my Excel. It is a simulation and take about an hour to run. I am testing it so I am running it often.
Any ideas why this could be happening?
I am running Office 365. The libraries I am referencing in VBA are:
- Visual Basic For Application
- Microsoft Excel 16.0 Object Library
- OLE Automation
- Microsoft Office 16.0 Object Library
- Microsoft Forms 2.0 Object Library
- Microsoft Scripting Runtime
- Microsoft Visual Basic for Applications Extensibility 5.3
Thanks
Thanks
- If I run the code several times, I cannot see my tabs at the bottom of my Excel. They are clearly there because if I click on where they should be Excel takes me to the tabs. And they are not turned off in my settings.
- I have also noticed that if I run the the code to much, I start to get errors in lines of code that normally work. I have to shut down excel and restart to get it going again.
- Sometime I also have to save the file under a new name to get it going again.
- Sometimes I cannot save newer versions of the file unless I change its name.
- I ran into an issue this evening where Excel would open but if I tried to Enable macros I would get an error message saying Microsoft Excel has to shut down. I restarted my computer and this solved the issue.
- My status bar tends to freeze up if there is too much mouse movement
Any ideas why this could be happening?
I am running Office 365. The libraries I am referencing in VBA are:
- Visual Basic For Application
- Microsoft Excel 16.0 Object Library
- OLE Automation
- Microsoft Office 16.0 Object Library
- Microsoft Forms 2.0 Object Library
- Microsoft Scripting Runtime
- Microsoft Visual Basic for Applications Extensibility 5.3
Thanks
Thanks