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

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

Does this follow for xp? The module in listed as general.

"Tom Ogilvy" wrote:

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

Bob

Yes. If the sub takes arguments, you'll get this behavior.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Bob wrote:
Does this follow for xp? The module in listed as general.

"Tom Ogilvy" wrote:

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