Cant Find Project or Library

[AllisterB]

I open up a xlsxm workbook and it gives me the error Can't Find Project or Library.

I have looked on eth net and most solutions involve going to Tools|Refrences and checking a box for the missing one - when i do this I can't get a reference List.

I then thought I would see if VBA was working and when I go to View Code on the Sheet I get eth Image attached. I also can't Record a macro as it doesn't like the name even if I give it a random name eg hhjklgk

When I try and save the file it says errors were detected when saving the file

Has anyone any ideas.

Allister

 

[AllisterB]

I have tried opening the file on different PC. I can now see the References, I don't get eth Error message about the Project or Library and I can save the file - what does this suggest is the cause of eth problem?

 

[RoryA]

What references are selected?

 

[AllisterB]

On the PC where teh file works see attched

 

[RoryA]

Are you sure you had the correct workbook open and active when you checked that? Those are the default references and none of them should cause the error you are getting.

 

[AllisterB]

I'm pretty sure -see attached and you can see I have the project for my file selected on the left.

no other References are ticked except those showing

 

[RoryA]

What versions of Office/Windows are in use on the two machines?

 

[AllisterB]

365 Win 10

 

[RoryA]

Both exactly the same?

 

[AllisterB]

Probably not exactly the same as one is on a semi-Annual office Update the other on Microsoft 365 Home. The Win10 updates may be slightly behind the other