View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Flanagan Bob Flanagan is offline
external usenet poster
 
Posts: 340
Default Compile error in hidden module: [user form name] Excel/VBA

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

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