Microsoft KB Archive/201584

= XL97: Private Functions Are Available to Worksheet =

Article ID: 201584

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q201584





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: XL97

Keywords: kbbug kbdtacode kbpending KB201584

-

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

© Microsoft Corporation. All rights reserved.