Sửa Lỗi Compile Error In Hidden Module

Can any solve sầu this issue , in my office someone receive sầu an Excel File & when I open I show an error ( compile error in hidden module module 1) , i have sầu do most of the tricks but not happen 

We are using Ms office 2010 , Ms 2013 both, but file 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: Sửa lỗi compile error in hidden module

1. From the tệp tin in question, press Alt + F11 go into lớn its Visual Basic Editor.2. From the Tools menu select References3. Scroll through the Available References listbox and untichồ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ồ liên hệ 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 file - the following link 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://support.microsoft.com/en-us/help/307410/you-receive-a-compile-error-in-hidden-module-error-m...

Xem thêm: Phdgd Now 3 - Phdgd Now Latest Version

There are other possibilities lượt thích the file is corrupt or you have e.g. reference issues - without further details hard khổng lồ tell... 

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


0
· · ·

Chipotle
OP
Best Answer
zevfriedman
This person is a verified professional.
Verify your tài khoản khổng lồ 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 inkhổng lồ its Visual Basic Editor.2. From the Tools thực đơn select References3. Scroll through the Available References listbox and untiông chồng any that start with MISSING:4. Press Alt + Q once all of these reference errors have sầu 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 & none of the other suggestions worked Except yours!!!!! You are AWESOME và thank you
0

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