Sharing Macros in Excel
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? |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com