XL2000: Private Functions Are Available to Worksheet (199200)
The information in this article applies to:
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.
STATUSMicrosoft 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 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.
| Modification Type: | Minor | Last Reviewed: | 9/12/2006 |
|---|
| Keywords: | kbbug kbpending KB199200 |
|---|
|