Is it a Function or Subroutine (Function or Sub)

Is it a Private subroutine -- Private SUB ....()

do you have
Option private Module ' Indicates that module is private.

Private subroutines and addins do not show in the macro list Alt+F8.

Functions do not show up in the list of macros, but do show up
in the Function Wizard [fx]

More information is in your VBA HELP

http://www.mvps.org/dmcritchie/excel...la.htm#another
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"ChuckM" wrote in message m...
Need help.... I developed a routine...works fine. Then I added a call
to this routine from my main routine and then the subroutine vanishes
from the edit list. How can I access this 'vanished' program.

thanks
chuckm