Can any solve this issue , in my office someone receive an Excel File và when I open I show an error ( compile error in hidden module module 1) , i have bởi vì most of the tricks but not happen 

We are using Ms office 2010 , Ms 2013 both, but tệp tin is not open properly ,

*
 

My excel setting 

*

*

Tnx 

DK:)



zevfriedman

You might be missing references. See solution posted here: https://www.mrexcel.com/forum/excel-questions/566811-compile-error-hidden-module-module-1-a-post2804...

Bạn đang xem: Lỗi compile error in hidden module

1. From the file in question, press Alt + F11 go into lớn its Visual Basic Editor.2. From the Tools thực đơn select References3. Scroll through the Available References listbox và untiông chồng any that start with MISSING:4. Press Alt + Q once all of these reference errors have sầu been unticked.


*

frossmark

ALT + F11 should open VBA - but your error says hidden Module1 - meaning you might not even see the module in VBA for Excel. 

You might need khổng lồ contact the source / developer of the file... 

Another possible issue could be your Excel Start Up folder - but that would mean you see the error with any Excel tệp tin - the following liên kết explains it on an example - but it could be anything in that folder that could cause it - assuming it comes up ALL the time - not just with one file! https://tư vấn.microsoft.com/en-us/help/307410/you-receive-a-compile-error-in-hidden-module-error-m...

Xem thêm: Axit Là Gì? Tính Axit Là Gì ? Tính Chất Của Axit, Hóa Học Phổ Thông

There are other possibilities like the file is corrupt or you have e.g. reference issues - without further details hard to lớn tell... 

What scares me is you write "someone received an Excel file" - hope this source is trustworthy! Especially in regards khổng lồ your macro security settings


0
· · ·

Chipotle
OP
Best Answer
zevfriedman
This person is a verified professional.
Verify your trương mục to lớn enable IT peers lớn see that you are a professional.
Oct 22, 2018 at 17:09 UTC

You might be missing references. See solution posted here: https://www.mrexcel.com/forum/excel-questions/566811-compile-error-hidden-module-module-1-a-post2804...

1. From the tệp tin in question, press Alt + F11 go into its Visual Basic Editor.2. From the Tools menu select References3. Scroll through the Available References listbox & untiông xã any that start with MISSING:4. Press Alt + Q once all of these reference errors have been unticked.


0
· · ·
Pimiento
OP
spicehead-8zvr1 Feb 11, 2019 at 22:31 UTC
1st Post
Serrano zevfriedman Your solution was perfect after I looked around all over the place and none of the other suggestions worked Except yours!!!!! You are AWESOME và thank you
0

This topic has been locked by an administrator and is no longer open for commenting.

Bài viết liên quan

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *