+ Reply to Thread
Results 1 to 7 of 7

Compile error in hidden module: Sheet 1

  1. #1
    Registered User
    Join Date
    05-27-2014
    Posts
    3

    Compile error in hidden module: Sheet 1

    Dear All,

    The error message :" Compile Error in hidden module: Sheet 1" appeared when I copied the worksheet I am working on to another laptop with the same MS excel version.

    In my laptop, it is working perfectly but not with the other laptop.

    part of the code:

    Please Login or Register  to view this content.
    Can you kindly help me.

    Thanks
    Last edited by alansidman; 05-28-2014 at 12:20 AM. Reason: code tags added

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Compile error in hidden module: Sheet 1

    Hi,

    Try unhiding the Sheet 1 module, and then the error will be more specific and I might be able to help you.

    Also, in future, please post code in between code tags (please read the forum rules), and use indenting as it makes your code easier to read and you are likely to get more help if you make more effort.

    Thanks

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    14,544

    Re: Compile error in hidden module: Sheet 1

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between
    Please Login or Register  to view this content.
    tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

  4. #4
    Registered User
    Join Date
    05-27-2014
    Posts
    3

    Re: Compile error in hidden module: Sheet 1

    Dear Ajryan88 and Alansidman,

    Noted. Will follow the rules.

    Thanks

  5. #5
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Compile error in hidden module: Sheet 1

    How did you go with unhiding the module?

  6. #6
    Registered User
    Join Date
    05-27-2014
    Posts
    3

    Re: Compile error in hidden module: Sheet 1

    What I did was to go to the Reference window and uncheck Microsoft Calendar then saved the workbook.
    Also I declared the variables.

    Now it is working fine but still testing in other units to be sure.

    Will update the thread once it is solved.

    Thanks Ajryan88

  7. #7
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Compile error in hidden module: Sheet 1

    Great to hear! No problems

    Glad to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1