excel 2003 error>> compile error in hidden module: ThisWorkbook

Discussion in 'Microsoft Excel Misc' started by clayton, Jun 17, 2004.

  1. clayton

    clayton Guest

    Hi, I created this worksheet in Office XP. Now I have a new compute
    with WindowsXP pro and Office 2003. This worksheet opens fine on othe
    machines but on mine I get

    "compile error in hidden module: ThisWorkbook"

    When I look at it in VBA and run it , it will stop on this line.


    response = MsgBox("This is my message to the user.", _
    If response = vbOK Then

    What is different in Office 2003 to make it have an error now
    clayton, Jun 17, 2004
    1. Advertisements

  2. Hi Clayton,
    There's probably something missing on your machine. Click on Tools >
    References and see if anything at the top starts with "MISSING: " If
    so, try unticking that library.


    Stephen Bullen
    Microsoft MVP - Excel
    Stephen Bullen, Jun 18, 2004
    1. Advertisements

  3. clayton

    clayton Guest

    Well, I am assuming that no one is having this problem...
    Could this be a courpt file in Office or something? I know very littl
    about excel so I am stumped.

    This is my whole Workbook_Open statement
    clayton, Jun 18, 2004
  4. clayton

    clayton Guest

    Wow, I was sure someone could help me here. This is the best resourc
    site I've ever seen for excel. Hrmm... Guess I'll have to work aroun
    it.. Just don’t make any sense..
    clayton, Jun 22, 2004
  5. Stephen Bullen posted an answer to your original question:


    Some messages don't seem to make it through to the Excel forum, so if
    you're posting through there you may miss things.
    Debra Dalgleish, Jun 22, 2004
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.