I have a workbook that shows up in VBE, but is not in Excel, neither hidden nor visible. It's one of the files that have a collection of macros. It's a file that is opened only on my computer.
In the VBE I can see all the modules, subs, functions, etc. I can run a sub, but when another workbook tries to access it, it can't be found.
This is not the first time this has happened. I'm pretty sure it has something to do with closing and/or opening files that have a reference (VBE, Tools -> References) set to another file.
Any idea what I may have done to get to this state?
Bookmarks