Make sure its a sub and not a function. Make sure it is not private.
--
Gary''s Student - gsnu2007c


"Len Case" wrote:

Hi all,,,,,,,can someone help with this please, I have a macro but it does
not show up under the TOOLS, MACRO, menu, the only way to to see the code is
to choose the VBA Editor and select the module and view code, but even then
I cannot do anything with it, if I click step into nothing happens.
Hopefully you can help.
Cheers
Len