Function not visible
Is the function header
Private Function MyFunction() as variant
or
Public Function MyFunction() as variant
Private won't be available, public should....
"JayL" wrote:
All-
Interesting occurence. I have a ColorIndex function that works well when
contained within a workbook. However, when in my Personal.xls file the
function is not visible. All other macros in personal.xls work fine.
Any ideas how to have this function always available?
-Jay
|