Function not visible

  • Thread starter Thread starter JayL
  • Start date Start date
J

JayL

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....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project Code Communication 2
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
functions in 'personal.xls' 4
personal.xls 2
Create employee attendance db using personal.xls? 3
Registering Function Macros 3
Call Macro from PERSONAL.XLS 4
Porting from Excel 2003 to Excel 2010 12

Back
Top