compile error in hidden module

W

Wanna Learn

Hello this started today when I closed excel I got the message
"Compile error in Hidden module Dist Mon
I selected help and this is what I got

Compile error in hidden module: <module name>

A protected module can't be displayed. This error has the following cause
and solution:

There is a compilation error in the code of the specified module, but it
can't be displayed because the project is protected.
Unprotect the project, and then run the code again to view the error.

For additional information, select the item in question and press F1(in
Windows) or HELP (on the Macintosh).

How do I know which protected mdoule ? How do I fix this error?
Thanks
 
B

Bob Phillips

Do you have any addins installed? If so, goto Tools>Addins and uncheck one
of them, then check it again and see if you get the message. Then try
another and so on until you get the message and thus know which one it is
in.
 
W

Wanna Learn

THanks for your help I have quite a few add ins. I deselected one at a
time and closed excel - open excel and slelected the same one again and
deselected the next one. I even deselected all of then and I still get the
same message compile error in hidden module Dist Mon What did I do wrong?
Again Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top