Excel Marcos and Programs

[Clive]

Hi, I have a worksheet with some programs/macros which
worked fine previously, but without doing any
modification, it can't work again, with error message
like "Compile error in hidden module: UserForms". Anyone
can help to solve this problem?

Thanks.

 

[Tom Ogilvy]

If you moved it to another machine, perhaps you are missing a reference.

 

[Guest]

Thanks, Tom, but I have my original worksheet from disc,
but only some machines able to run it, with all machines
have same software version of XP and Excel 2002. If it is
the case that missing a reference, how can I fix the
problem?

Thanks,
Clive.

 

[Tom Ogilvy]

when you run into the problem, go to Tools=>Reference and see if a reference
is shown as MISSING.

If so, you need to either remove the reference from the original file on the
original machine (if you are not using it). Then use that new version on the
troubled machine. Or you need to find the reference on the machine with the
problem using the browse button (or install it if it isn't there).