Compile error in hidden module: Sheet 1

**rookrose** · 05-27-2014, 12:03 PM

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

**ajryan88** · 05-27-2014, 10:52 PM

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

**alansidman** · 05-28-2014, 12:20 AM

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

**rookrose** · 05-28-2014, 01:00 AM

Dear Ajryan88 and Alansidman,

Noted. Will follow the rules.

Thanks

**ajryan88** · 05-28-2014, 01:04 AM

How did you go with unhiding the module?

**rookrose** · 05-28-2014, 01:57 AM

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

**ajryan88** · 05-28-2014, 01:59 AM

Great to hear! No problems

Glad to help

Compile error in hidden module: Sheet 1

LinkBack

Thread Tools

Rate This Thread

Display

Compile error in hidden module: Sheet 1

Re: Compile error in hidden module: Sheet 1

Re: Compile error in hidden module: Sheet 1

Re: Compile error in hidden module: Sheet 1

Re: Compile error in hidden module: Sheet 1

Re: Compile error in hidden module: Sheet 1

Re: Compile error in hidden module: Sheet 1

Thread Information

Users Browsing this Thread

Similar Threads

Compile error in hidden module sheet 1

[SOLVED] Compile Error in Hidden Module and Compile Error: Can't find project or library

"Compile Error in hidden module in sheet 1" in excel

Compile error in hidden module

compile error in hidden module.....

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions