Compile error in hidden module: [user form name] Excel/VBA

[Carlos]

I have created an Excel workbook that uses user forms for data entry. This
workbook is available online via our intranet and several users are
reporting that they are getting a "Complie error in hidden module:
<userform>". I've read the other forums related to the moving of the
pfdmaker.xla or pdfmaker.dot files but I want to know if there is anything I
can do to my workbook to prevent this error from occuring. There is no
possible way that
I can get to every pc with the error and I don't think that my users are
savy enough to make the fix on their own. Not to mention if they are
getting the error due to Norton Antivirus. I should also mention that I have
users using a variety of Microsoft operating systems and office versions.
Thanks in advance for any solutions or suggestions.

 

[Bob Flanagan]

If the code works fine on your machine and others, doing the same steps,
then the likely cause is a bad installation of Office. That can happen if
the PC came with Excel pre-installed. Ask the users with the problem to do
an Office repair in Add/Remove Programs, Microsoft Office. If that doesn't
cure, then have them reboot, un-install Office, reboot again, and
re-install.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel