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

I managed to get remote connection to the pc in the other office.
The same file opened from shared hdd works there.
the difference i see is that e.g.

commandbutton was originally class commandbutton
the desktop in the other office changed it to class commandbutton2

this has been done for all objects, even named ranges doesnt work.

any ideas how to revert those changes made by the desktop so that the file is not screwed please?

thanks,
Peter

and lastly the problem seems to be reference MS Forms that is creating #2 of each object class.
the desktop was 32bit using /system32/FM20.DLL while laptop is using /sysWOW62/FM20.DLL

can this be the reason? Is 32 and 64 bit OS using different MS forms?

thanks,
Peter