File works in 2007 but gets compile error in 2010

Hi All,

I have a file but am unable to post it as it is a work file and I have to restrict who can see it but, I would like some help if possible.

When I try and open the file in excel 2010 at home I get the following error "Compile error in hidden module sheet 19" however the file opens up fine at work in excel 2010.

I am wondering if there is something missing in my excel at home or something that I need to change so that the file can open and work just like at work. Again I am sorry I cant post the file due to security reasons but any help would be much appreciated.

Thank you

Maybe you are missing a library on your home machine. Suggest opening the file at work, go to the VBA editor (Alt F11) - Tools - references. Take a note of the selected references. Then see if you have these available at home.