![references vba project excel 2016 references vba project excel 2016](https://www.superexcelvba.com/static/images/en/tutorial/enabling-libraries.png)
* Microsoft Office 16.0 Object Library (again) There are No MISSING items listed at all. Thanks for your reply! I did already try that - ie I close all other excel files & open up a new excel file and yes, then I can get into Tools>References Dialog. Help! Sorry for long msg, but I'm trying to provide as much info as I think you might need to help me. It's not greyed out, but it will not fire up. However, when I try do this, I cannot even get the Reference Dialog to open up at all. I see by google searching the "Can't find Project or Library" error, that a lot of the solutions seem to involve opening up the file, going into VBE, > Tools> References Dialog where I look for and uncheck specific "MISSING" items. When I opened it at work, saved it back onto my Work PC, it opened fine, no problems - this was maybe 2 weeks ago - and it's been okay until today. So I saved it on myPC, then emailed it back to work. At home, where I also run Office 365, it opened perfectly fine. So rather than 'rebuild' I decided I would take the misbehaving MyWB home to my own PC (I emailed it to myself). Or if the something that out ESET security app was doing.
#References vba project excel 2016 update#
The last time it happened, I began to wonder if it was some update that is causing the problems. Then off it goes, fine until the next time it happens. Twice I have 'rebuilt' the broken File - by exporting each 'form''module' 'this workbook' out of a back up copy of MyWB- then creating a new workbook, moving the up-to-date worksheets from MyWB, then importing the project items ( 'form''module' 'this workbook') back in. I have many other xlsm workbooks, which open fine. If I persist, the dialog : 'Visual Studio Just-in-time Debugger' pops up, stating "an unhandled win32 exception occurred in EXCEL.EXE (2960)" with The Possible Debuggers: New Instance of Mirosoft Office Studio 2010" Issue: Since the start of this year, MyWB has 'crashed' 4 times - in as much as it wont load the Project (msg: "Can't find project or library". Aside from the recurring issue below, it operates smoothly.
#References vba project excel 2016 code#
Within the Project it has Forms, Modules, code that controls how it opens, closes, activates, presents and so on. The Wb (lets say MyWB) is behaving as a database. MS Office 365, has been on the machine for past 2 years.
![references vba project excel 2016 references vba project excel 2016](https://www.bluepecantraining.com/wp-content/uploads/2017/05/File-Management-1.png)
Problem with: A specific MS Excel File (xlsm), that has been working perfectly fine since 2013. At my Workplace which is a Home Office, running PC: