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.