Hello All,
to describe what i have done:

all xlsm files have been made in my work laptop (everything was working)

then i went to different office for several weeks and have been updating workbooks (pivot data and/or macros), they have been working on that machine and i have copied them to shared hard drive, my manager however wasnt able to run those macros
now i am back and none of those are working on laptop either

macros from modules are working
macros in excel objects (sheets) are not
many of the objects have been renamed (e.g. i have had 36 labels named based on their purpose, now they are named as Label1 till label36, many objects when you click on them in the object browser read "LabelActiveDuration as <unnamed>")
when i create a new sub within sheet it works
when running subs from sheets it returns "compile error: object library invalid or contains references to object definitions that could not be found"
another error: runtime error 32809

i assume all this is happening because of the <unknown> object definition, is there any way how i can search for all these occasions in object browser and fix them?

Thanks,
Peter