Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

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

  1. #1
    New Member
    Join Date
    Oct 2007
    Location
    Seattle
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

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

  2. #2
    Board Regular Oorang's Avatar
    Join Date
    Mar 2005
    Posts
    2,071
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    • Get better answers! Include your version of Office in your post.

  3. #3
    New Member
    Join Date
    Oct 2007
    Location
    Seattle
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,832
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

  5. #5
    New Member
    Join Date
    Oct 2007
    Location
    Seattle
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Erik,

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

    Matt

  6. #6
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,832
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you're welcome!

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

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

  7. #7
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,832
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    run this code
    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?
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

  8. #8
    New Member
    Join Date
    Oct 2007
    Location
    Seattle
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  9. #9
    New Member
    Join Date
    Oct 2007
    Location
    Seattle
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    run this code
    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!

  10. #10
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,832
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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)
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •