not able to access the macro.

Question

Hi,

 I'm not able to access macro, could you please  help me on this!

Answer 1

With that less on information no one can guess anything.

What happens when you press key combination <Alt> + <F11>? Do you get an error message?

Ist VBA / macros installed at all; is an optional installation feature?

Answer 2

hen i click run report, it was popping up a error message the message is " compile error in hidden module: module9. this error commonly occurs when code is incompatible with the version, platform, or architecture of this application. click help for information on hoe to correct this error' this subject is popping up,

Answer 3

Hi @Nagarjuna, Yenakandla

Here is a reference about this eorror: Compile error in hidden module: <module name>.

• Check if the VBA code in the document is compatible with the architecture of your Office version. If the code targets 32-bit Office applications but you are running a 64-bit Office version, it can cause this error. In this case, you can try running the code on a compatible version of Office.
• If you have access to the VBA code in the document, unprotect the module, and then run the code again to view the specific error.
• If you don't have access to the VBA code in the document, then contact the document author to have the code in the hidden module updated.

Please also go to VBA Editor and select "Tools" > "References." Search for any references that aren't there and are either marked as "MISSING" or have different version numbers. If you do, uncheck them, click "OK," and then try checking them again.

Third-party add-ins may occasionally clash with VBA code. To see if the problem still exists, try disabling or uninstalling any third-party add-ins.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---