Microsoft KB Archive/199200

= XL2000: Private Functions Are Available to Worksheet =

Article ID: 199200

Article Last Modified on 9/12/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q199200





SYMPTOMS
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.



CAUSE
This problem occurs when you do the following:

You use the Private Function statement.

-or-

You use the Option Private Module statement.



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



MORE INFORMATION
You can create a user-defined function and make it private to the subroutine by using the statement Private Function. 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.

Additional query words: XL2000

Keywords: kbbug kbpending KB199200

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.