Compile Error in Hidden Module: This Workbook

I have a client with an active Excel spread sheet that has been sent to me that when I open it with Excel I initially get a security warning that says "Some active contect has been disabled" I click on options and tell it to "enable this content"  and that is when I get a Microsoft Visual Basic Error "Compile error in hidden module: ThisWorkbook".  I have tried opening it with Excel 2003, 2007 and 2010 with the same problem.  Others that receive the same speadsheet tell that they are not having any problem with it.  I have tried 3 different computers with different OS and version of Excel.  What am I doing wrong here?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Michael FowlerSolutions ConsultantCommented:
This can be caused by add-ins. Try starting excel in safe mode (hold ctrl while opening excel) and open the file from there.

waytronAuthor Commented:
I wish it were that simple. But I still get the same error when I start excel in Safe mode.
Glenn RayExcel VBA DeveloperCommented:
It sounds like you and others receiving this error may be missing some library files, or have outdated versions.

For example, if the workbook contains ActiveX controls in forms and those files aren't on the client machine, you'll see this error.  Or, if the application calls an Outlook event (ex., mailform) and the version is different, you might see an error.

Compounding this is that the VBA project for this workbook is likely locked for viewing and password-protected.  That is behavior like an add-in, but can be applied to any workbook with VBA code.

The only way to really debug this would be to unlock the VBA project and try compiling the code and look for the error.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
waytronAuthor Commented:
The sheet is a form with all kinds of drop down menus.  It was designed and distubuted by a large corporation and sent out to all their reps to fill out.  I have givien up on it and refered the problem back the the creator of the file.
waytronAuthor Commented:
Thank you for your assistance
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.