How do I get only the macro name and not the full path to show in the MACRO
run box. The Path is longer than the box so that I cannot see the macro name.

make that workbook the active workbook.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Richard" wrote in message
...
How do I get only the macro name and not the full path to show in the
MACRO
run box. The Path is longer than the box so that I cannot see the macro
name.

One other thing I've found that causes that is naming the module and the
macro the same. If that is the case, change one of the names.

"Richard" wrote:

How do I get only the macro name and not the full path to show in the MACRO
run box. The Path is longer than the box so that I cannot see the macro name.