Make sure you put it in a general module and not in a sheet or the
thisworkbook module.

--
Regards,
Tom Ogilvy

"Bob" wrote in message
...
how can I use a macro that starts with public sub.
This will not be recognized by my macro list and run remains greyed out
when
I type the macro name