title: How can I hide Protected Excel AddIn Functions from Appearing in Insert Function Dialogue Box?
body: <p>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.</p>
  
  <p>This happens even if you password protect the project and lock it for viewing.</p>
  
  <p>To get to the "Insert Function" dialogue box press Shift-F3.</p>
  
  <p>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.</p>
  
  <p>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?</p>
  
  <p>Thanks!</p>