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

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