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...
Xem thêm: Cách: Root Và Cài Recovery Cho Lg G3 D855, Hướng Dẫn Root, Thay Recovery Cho Lg G3
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.
Chuyên mục: Công Nghệ