Hello,

I have a strange issue.
When I try to open my excel file on a different computer and run my macro, nothing happens.
When I try compiling, I get "Compile error: Object library invalid or contains references to object definitions that could not be found."
However, if I create a new workbook and then copy over all the modules, the macro works fine.
When I try copying over all the worksheets to the new workbook, everything but the fill color transfers over nicely.
The fill color are all a different color.

Can someone help me fix this issue?
I'm not sure what is going on.

Thank you in advance.