I am running Excel 2000. I've been able to create a macro
to put the pathname in the footer, and assign that macro
to a toolbar in order to make it available in any
workbook, but as the macro runs, the workbook in which the
macro was originally created is opened, and remains open.

I would like to make the execution cleaner in order to
share the macro with others in my office with a minimum of
confusion about its execution. Is there any way to create
a macro such that it does not require that the original
workbook be opened? Or such that it automatically closes
the workbook that it opened once the macro in question is
executed?