PC Review


Reply
Thread Tools Rate Thread

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

 
 
Carlos
Guest
Posts: n/a
 
      30th Apr 2007
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.
 
Reply With Quote
 
 
 
 
Bob Flanagan
Guest
Posts: n/a
 
      30th Apr 2007
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Compile Error in Hidden Module 2 =?Utf-8?B?RXJpbg==?= Microsoft Excel Misc 3 26th Oct 2004 08:49 PM
compile error in hidden module in excel =?Utf-8?B?bTAzam9obg==?= Windows XP General 2 15th Oct 2004 12:28 AM
Excel : Compile error in hidden Module =?Utf-8?B?ZWxsZQ==?= Microsoft Excel Crashes 4 21st May 2004 04:40 AM
Compile error in hidden module in Excel 2002 Cindy Fairchild Microsoft Excel Misc 6 17th May 2004 11:28 PM
compile error in hidden module with excel 2003 Brian Murphy Microsoft Excel Programming 2 7th Apr 2004 11:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:10 PM.