Can't Find Project or Library...?

[chazrab]

I go thru this every time I reinstall O365.

I get a "Can’t find Project or library dialog box" on this first line of code

colnum = Round((Date - DateValue("12/20/2017")) / 7, 0)

with 'Date' highlighted in blue.
In the Tools References dialog box
Microsoft Windows Common Controls-2 6.0(SP6) in the controls dialog box is checked.
It won’t let me uncheck it. The dialog box says – “can’t remove control or reference – in use. Whether this is related to the problem
I don't know.

I fixed this very easily in past years, but I can't remember how I did it. Unchecking MISSING: item seemed to fix it but I can't seem to figure out what Excel is telling me other than it can't find what its looking for.
Can someone please help me fix this.

Thanks for anyone's help.
cr

 

[Peter_SSs]

Not sure whether this will help but I has something of a similar problem recently. I got that message every time I opened a particular file and couldn't find out what was "missing". I eventually restored a copy of the file from a backup and the problem disappeared, so I have put it down to a corrupted file.

Do you only get this message in relation to this workbook?
Do you have a backup to restore from? If not, are you able to copy the data & vba into a fresh workbook and see if that one behaves better?