compile error in hidden module: DistMon (MS Visual Basic)

[mattach]

Hi,
I keep getting that message everytime I open and then close excel. I think it has something to do with Acrobat as it started once I loaded Acrobat onto my computer but I do not know how to make it go away. Word and Powerpoint work just fine.

When I click on HELP next to it, I get the following message:

Compile error in hidden module: (module name)
A protected module cannot be displayed. The error has the following cause and solution:
- There is a compilation error in the code of the specified module, but it cannot be displayed because the project is protected.
- Unprotect the project and then run the code again to view the error
For additional information, slect the item in question and press F1.

I am not technical at all and totally unsure of what to do. Any help would be much appreciated.

Thanks!!

 

[Oorang]

That error is caused when you have a password protected project loading that has an error in it. When code tries to execute it auto compiles, if there is a syntax error in it, and the project is protected you will receive that error. If You get it with every workbook you open it is most likely an addid. Try turning all you addins off, then opening a workbook. If the error stops then you just begin turning the addins on one by one until you get the error again then you will know which one is the guilty party.

 

[mattach]

Thanks - unfortunately, I did check that and I have no add-ins turned on right now.

 

[erik.van.geit]

Hi, mattach
Welcome to the Board!!!!

Thanks - unfortunately, I did check that and I have no add-ins turned on right now.

Try this:
Close Excel
Rightclick in any Folder (I would use the desktop) and select New/Excelfile
Open that file

Do you get the error?

kind regards,
Erik

 

[mattach]

Hi Erik,

Thanks. I just tried that and I still get the same message when I open and shut Excel down. Frustrating.

Matt

 

[erik.van.geit]

you're welcome!

please describe what you see in the left pane of your VBA-Editor
(list of available workbook projects & modules)

 

[erik.van.geit]

run this code

Sub list_addins()
Dim Add_In As AddIn
Dim i As Long

Workbooks.Add

    For Each Add_In In AddIns
        If Add_In.Installed = True Then
        i = i + 1
        Cells(i, 1) = Add_In.Name
        End If
    Next Add_In

End Sub

what do you see on the sheet?

 

[mattach]

you're welcome!

please describe what you see in the left pane of your VBA-Editor
(list of available workbook projects & modules)

not sure how to do this. where would i look? i am technical but not a pogrammer or anything like that.

 

[mattach]

run this code

Sub list_addins()
Dim Add_In As AddIn
Dim i As Long

Workbooks.Add

    For Each Add_In In AddIns
        If Add_In.Installed = True Then
        i = i + 1
        Cells(i, 1) = Add_In.Name
        End If
    Next Add_In

End Sub

what do you see on the sheet?

hmmm - how would i do this?i am not a programmer.

thanks!

 

[erik.van.geit]

you're welcome!

please describe what you see in the left pane of your VBA-Editor
(list of available workbook projects & modules)

not sure how to do this. where would i look? i am technical but not a pogrammer or anything like that.

Open a new workbook in Microsoft Excel, and start the Visual Basic Editor (via Menu Tools, Macro or press ALT+F11).
What do you see in the left area? (under the header Project VBA-Project)
(if necessary press Ctrl+R to see the Projects)