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.

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

--
Regards,
Tom Ogilvy

Clive wrote in message
...
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.

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.

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

--
Regards,
Tom Ogilvy

Clive wrote in
message
...
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.


.

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).

--
Regards,
Tom Ogilvy

wrote in message
...
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.

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

--
Regards,
Tom Ogilvy

Clive wrote in
message
...
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.


.