Hi. I posted a few days ago about this problem and forgot to attach an example.
I have created a customer database in excel using a sheet full of vlookup cells, and some macros doing various tasks.
This was working perfectly up until recently. Unfortunately I performed a few different maintanence steps all at once without proper testing in between so cant be sure what has cuased this.
Empty Master Help.xlsm
Symptoms:
- Random crashing of excel. Usually when the worksheet is sat idle, but also occasionally on save.
- Occasional "object not-found" when calling the "weeks" userform. When this happens, if i open vba editor and attempt to view the userform, excel crashes.
Changes prior to problems
-Used code cleaner to clean code up
-Copied all data (values) and code to fresh worksheet to remove file links caused by prior copy/paste
-Included icons to replace command buttons (since removed)
Empty Master Help.xlsm
Steps performed to try and fix;
-Create a separate module for each macro
-Removed pictures
-Disabled splash screen and timer (made no difference so re-enabled)
-Disabled ALL thisworksheet code (again made no difference)
Empty Master Help.xlsm
Im sure the error is simple and blatant but I am stuck. The crashes are causing significant frustration in the office. Any assistance would be received gratefully.
Thanks in advance. Empty Master Help.xlsm
Bookmarks