I created a spreadsheet for work that uses quite a bit of macros that I wrote in VBA.
Everything was running well, until I attempted to add a splashscreen, that launches a macro. The macro performs a web query on a small website, and if a cell range is valid, it continues running. If not valid, it closes the workbook.
I saved the file.
Now when I try to load the file, I get the following Error.
"Error in loading DLL"
I went to VBE and checked TOOLS>REFERENCES
and there is a MISSING: Ref Edit Control listed.
I try to uncheck the box and I get the error "Can't perform requested operation"
I'm at a complete Loss.
I have noticed that I can't pull up any of the Modules....
Any suggestions would be greatly appreciated!
Bookmarks