XL2000: Private Functions Are Available to Worksheet

When you create a user-defined function in Microsoft Visual Basic for Applications, you can use the function in the worksheet even though you have declared it as Private or you have used Option Private Module.

This problem occurs when you do the following:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

You can create a user-defined function and make it private to the subroutine by using the statement Private Function name. Or, you can make it private to the module by using the statement Option Private Module.

Although you can manually enter a private user-defined function into a worksheet cell, the function is not listed in the User-defined function category in the Paste Function dialog box.

NOTE: A function listed as Private will not conflict with built-in functions or defined names with the same name.