Which of the following retains the information it's storing when the system power is turned off?


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

*

*

*

*

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...Quý Khách đang xem: Lỗi compile error in hidden module

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 và untiông xã any that start with MISSING:4. Press Alt + Q once all of these reference errors have sầu been unticked.




Xem thêm: Đeo Vàng Ta Có Bị Hao Mòn Không, Đeo Vàng Ta Có Tốt Không

*

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 lớn contact the source / developer of the tệp tin... 

There are other possibilities like 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 lớn your macro security settings

0 · · ·ChipotleOPBest Answer zevfriedman This person is a verified professional. Verify your tài khoản to lớn enable IT peers khổng lồ 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 inlớn its Visual Basic Editor.2. From the Tools thực đơn 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.

0 · · ·PimientoOPhường. spicehead-8zvr1 Feb 11, 2019 at 22:31 UTC 1st PostSerrano zevfriedman Your solution was perfect after I looked around all over the place và 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.