M
michael_amon
I have written a graph analysis macro using VB (Excel 2000 Premium) and
assigned a customized toolbar / icon to the macro. It runs well, but
it's helpful to rename the file after an analysis is complete under a
more desriptive name.
When I do this however, even though the macro is still present in the
newly named file (under Tools-macro-macros...) the icon is looking for
the macro from the original file, and then opens the original file to
run the macro in the newly created file. So I end up with 2 different
instances of Excel running. Is there any way that an icon can be
assigned to macro and remain specific for that workbook, regardless of
the workbook's actual filename?
I hope that my description is clear enough!
Cheers,
Mike
assigned a customized toolbar / icon to the macro. It runs well, but
it's helpful to rename the file after an analysis is complete under a
more desriptive name.
When I do this however, even though the macro is still present in the
newly named file (under Tools-macro-macros...) the icon is looking for
the macro from the original file, and then opens the original file to
run the macro in the newly created file. So I end up with 2 different
instances of Excel running. Is there any way that an icon can be
assigned to macro and remain specific for that workbook, regardless of
the workbook's actual filename?
I hope that my description is clear enough!
Cheers,
Mike