Compile error in hidden module. Module 1

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Compile error in hidden module. Module 1

  1. #1
    New Member
    Join Date
    Jul 2010
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Compile error in hidden module. Module 1

     
    Hi Guys,

    I am getting the above error message whenever I try to open up my spreadsheet. I am using excel 2010 currently but the sheet was created in excel 2007. How can I solve this ?

    Neo

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,494
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Compile error in hidden module. Module 1

    What happens if you hit Debug? If you don't get that option, then see if you can unprotect the VBA project and try opening it again.

  3. #3
    New Member
    Join Date
    Jul 2010
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Compile error in hidden module. Module 1

    The debug option is not there. It does not allow me to do anything. The message says that this error commonly occurs when the code is incompatible with the version platform.

  4. #4
    Board Regular
    Join Date
    Jul 2007
    Location
    Sydney
    Posts
    3,812
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Compile error in hidden module. Module 1

    I dare say either you've upgraded recently or someone has used and saved the file in a from different version of Excel than the file was created in as some of the DLL's are located in different path locations between versions.

    See if these four steps help:

    1. From the file in question, press Alt + F11 go into its Visual Basic Editor.
    2. From the Tools menu select References
    3. Scroll through the Available References listbox and untick any that start with MISSING:
    4. Press Alt + Q once all of these reference errors have been unticked.

    HTH

    Robert

  5. #5
    New Member
    Join Date
    Jul 2010
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Compile error in hidden module. Module 1

    Hi Robert,

    I cannot get into the Visual Basic Editor. When I load the program from my memory stick the message appears. I am unable to do anything, all I get is the message. I tried the Alt F11 but nothing happens.

    Thx
    Neo

  6. #6
    Board Regular
    Join Date
    Jul 2007
    Location
    Sydney
    Posts
    3,812
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Compile error in hidden module. Module 1

    Open the file without enabling macros i.e. click on Disable Macros (if the macro security setting is set to medium) and then try my four steps suggested above, save and close the file and try again with the macros enabled.

  7. #7
    New Member
    Join Date
    Jul 2010
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Compile error in hidden module. Module 1

    How do i open the file without enabling macros ? Once the file is open I cannot do anything.

    Thx
    Neo

  8. #8
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,494
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Compile error in hidden module. Module 1

    Quote Originally Posted by neo2 View Post
    How do i open the file without enabling macros ? Once the file is open I cannot do anything.
    IN Excel 2007+ goto File-->Options-->Trust Center-->Trust Center Settings-->Macro Settings-->Disable all macros with notification. Then close and restart Excel.

  9. #9
    New Member
    Join Date
    Jul 2010
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Compile error in hidden module. Module 1

    Thanks for the help. I was able to solve.

  10. #10
    New Member
    Join Date
    Sep 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Compile error in hidden module. Module 1

      
    Hi!

    I want to work on some cell protected worksheet. After going to visual basic editor in tools menu, I am unable to tick on references as its faded or not linked. Please help.

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
  •  

 

 
DMCA.com