only the macro name and not the full path to show in the run box

R

Richard

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.
 
B

Bob Phillips

make that workbook the active workbook.

--
HTH

Bob Phillips

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

Richard said:
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
Click to expand...
name.
 
J

JMB

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.
 
Top