Create private macro/function

Originally Posted by vbace2

Is there a way to create a private function and/or macro that can be seen by all modules in a spreadsheet, but can't be viewed in Excel by looking at the macros list? I have a number of modules in one workbook and I want to create one function that any macro in any of the modules can see, but it can't be seen by looking at the macros in Excel (i.e. ALT-F8).

Thanks

Hi vbace2,

To hide the macro from the list, put the following at the top of your Modules.

Option Private Module