How can I hide Excel Addin Protected Functions from the Insert Function dialog box?

Question

I recently discovered that all public functions are displayed in the Insert Function dialog box when you select Custom from the drop-down list of "Or select a category."

This happens even if you protect the password from the project and block it for viewing.

To go to the Insert Function dialog box, press Shift-F3.

Private functions do not appear in the list, but it is impossible to make all functions private, especially if you want to reuse them for all modules.

Is there a way to disable public functions stored in a secure add-in in the Insert Function dialog box in Excel?

Thanks!

Answer 1

Adding the following code to your module will make public functions available through the code, but will hide them in this dialog box.

Option Private Module