Excel Marcos and Programs
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. |
Excel Marcos and Programs
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. |
Excel Marcos and Programs
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. . |
Excel Marcos and Programs
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. . |
All times are GMT +1. The time now is 02:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com