Hello All,
I am trying to figure out a problem that I have created for myself. I have a document that has a couple of macros the run as soon as the workbook is closed. This part is fine and it all works the problem is that now that several people are using this document any updates that I need to make to this code I have to manually edit each copy of the document. So what I want to do is have the macro act like a tool. I know I can use an add-in but then I would need to get everyone to install it.
Is there a way to just call a macro from a closed document.
Thanks
residnt
I am trying to figure out a problem that I have created for myself. I have a document that has a couple of macros the run as soon as the workbook is closed. This part is fine and it all works the problem is that now that several people are using this document any updates that I need to make to this code I have to manually edit each copy of the document. So what I want to do is have the macro act like a tool. I know I can use an add-in but then I would need to get everyone to install it.
Is there a way to just call a macro from a closed document.
Thanks
residnt