public sub

[Guest]

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

 

[Tom Ogilvy]

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

 

[Guest]

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

 

[Dick Kusleika]

Bob

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