Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing Macros | Excel Worksheet Functions | |||
sharing macros | Excel Discussion (Misc queries) | |||
Sharing Macros | Excel Discussion (Misc queries) | |||
Sharing workbook with macros | Excel Discussion (Misc queries) | |||
sharing macros | Excel Discussion (Misc queries) |