Hi all,
Is it possible to store (and use) a macro not associated with a particular workbook?
I have developed a macro (with help from Andy Pope - many thanks!) that plots a graph from data entered into a form, the workbook containing the form plus graph is then saved with a new name. I would like to also apply the same macro to archived data, stored in the same form, but without the macro. It would also make life a lot easier if I need to change anything in the macro, if all the workbooks access the same macro instead of their own copy.
Thank you in advance
Steve
Bookmarks