Can't Find Project or Library

[Maleficent]

I've now encounted this issue a few times. I have different spreadsheets with VBA code which work fine and then all of a sudden one day stop working. Throwing up "can't find project or library" errors when opening, when trying to open "References" nothing happens. No changes have been made to the code or workbook between it working perfectly one day and crashing the next.

any ideas?

[Leith Ross]

Hello Maleficent,

Maleficent is one of my favorite movies. These issues are usually caused by registry errors, which like the disk, becomes fragmented overtime. First, you should defragment your disk and check it that solves the problem. If not then you will need to purchase a program to defragment the registry. I bought one 15 years ago and have very few problems anymore.