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!!

 

[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?

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

thanks!

open VBA-Editor (if not already open) (see my reply just before this one)
On the Insert menu in the VBE, click Module. (if necessary)
In the module (the white area at the right), paste code.

to run the code
click anywhere in the code and hit function key F5
or
via Excel menu: Tools / Macro / Macros (or hit Alt+F8)

 

[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.

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)

OK - I see a folder called Microsoft EXcel Objects and then under it 3 Sheets labeled Sheet 1, Sheet 2 and Sheet 3 and also an excel spreadsheet called ThisWorkbook

 

[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!

open VBA-Editor (if not already open) (see my reply just before this one)
On the Insert menu in the VBE, click Module. (if necessary)
In the module (the white area at the right), paste code.

to run the code
click anywhere in the code and hit function key F5
or
via Excel menu: Tools / Macro / Macros (or hit Alt+F8)

I did it, and it created a second exact replica of the first - they are now called VBAProject (Book 1) and VBAProject (Book 2) and have the same exact info underneath each one.

 

[mattach]

i then shut excel down again and the same error message came up

 

[erik.van.geit]

OK - I see a folder called Microsoft EXcel Objects and then under it 3 Sheets labeled Sheet 1, Sheet 2 and Sheet 3 and also an excel spreadsheet called ThisWorkbook

"Microsoft EXcel Objects" is under a header like VBAProject ("Book1")

I did it, and it created a second exact replica of the first - they are now called VBAProject (Book 1) and VBAProject (Book 2) and have the same exact info underneath each one.

as mentioned above you should see VBAProject ("Book2")

some more attempts:
press the arrow UP nothing above those projects?
when running the code, another book was added, what did you see on the active sheet?

 

[erik.van.geit]

Hi,

Doing a search on this forum (see link on top of the page), I found this
http://www.mrexcel.com/board2/viewtopic.php?t=289838
Should be "the" thread to solve your problem.

kind regards,
Erik

 

[mattach]

Hi,

Doing a search on this forum (see link on top of the page), I found this
http://www.mrexcel.com/board2/viewtopic.php?t=289838
Should be "the" thread to solve your problem.

kind regards,
Erik

Thanks Erik! Will check this out!

Matt

 

[mattach]

It worked!

Thanks Erik.

 

[erik.van.geit]

you're WELCOME

I'm glad it helped, but also learned something new today, thanks to you!