1

I recently discovered, however, that all public functions are displayed in the "Insert Function" dialogue box when you select "User Defined" in the "Or select a category" drop down list.

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

To get to the "Insert Function" dialogue box press Shift-F3.

Private functions are not displayed in the list, but it is impossible to make all functions private, especially if you want to reuse them across modules.

Is there a way to prevent public functions stored in a protected add-in from being displayed in the "Insert Function" dialogue box in Excel?

Thanks!

Kuyenda
  • 4,529
  • 11
  • 46
  • 64

1 Answers1

3

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

Option Private Module
Irwin M. Fletcher
  • 2,606
  • 3
  • 25
  • 29