Share via

Excel - Compile error in hidden module: modCertificateFct

Bigfoot 0 Reputation points
2023-08-14T02:15:54.6733333+00:00

I need to work on an Excel file which works perfectly on my colleagues' laptops. I have allowed Macros in the Properties window, and allowed VBA Macros, Enabled Excel 4.0 macros and trusted access to VBA project object model.

Active X Settings are enabled.

I can click on all the other cells, but as soon as I hover the mouse over the selection bocks, I immediately get the error.

Certificate Generator Error

Can anyone please offer fuidance?

Regards

Microsoft 365 and Office Development Other
Microsoft 365 and Office Excel For business Windows

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tanay Prasad 2,250 Reputation points
    2023-08-16T06:36:14.4133333+00:00

    Hi,

    This error usually indicates an error with your code.

    But since the workbook is working fine on your colleagues' laptop, it might have something to do with your environment.

    Here are some things you can try-

    1. Disable Add-ins
    2. Repair/Reinstall Office
    3. Update Excel
    4. Check for Missing References

    If these methods do not work out, you can also try the methods mentioned in this article.

    Best Regards.

    0 comments
  2. Bigfoot 0 Reputation points
    2023-08-16T20:09:24.61+00:00

    I managed to get the sheet working by re-installing Excel.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.