XL97: Private Functions Are Available to Worksheet

• Microsoft Excel 97 for Windows

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 this to be a problem in the Microsoft products 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.

Additional query words: XL97

Keywords : kbdta kbdtacode xlvbainfo
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug