If u want that your macro will appear in Macro list then you have to define yourmacro as SUB/PUBLIC only insted of PRIVATE.