how to unhide a hided module in an Excel file?

[Shanegg]

I have a module in one of my Excel file that is hidden. I'd like to keep it hidden but I'd like to use AutoKeys to run code to unhide it.

[zmbd]

We would have to know which version of Office/Excel you are using as the security model changed between versions. Also, I would highly advise against doing this in Office2010 and newer because you have to set some of the VBA security so that it may allow malicious code to alter the VBA container.

What I would suggest is locking and password protecting the modules, at minimum, and in standard modules use the one can add Option Private Module just below
Option Explicit to hide any macros therein from the Ribbon Macro dialog. OR, you can simply add the word Private before each sub/function-procedure within the module that you do not want exposed (like one would in a class module) and this is the only way to hide the procedure within sheet level code.

Perhaps an explanation of what you are after here would help.

BTW: Storing the password in AutoKeys isn't the safest either... black-hats know about this and there are exploits in the wild that can, and have, used this method to their advantage.