gowthron
07-08-2010, 02:45 AM
Folks,
I don't know if this is possible so I thought I would post the question and see if anyone has done anything similar before.
A writing a huge macro with lots of different functions and procedures which will be applied to a basic data.xls sheet. (Macro contained in another workbook which is referenced through toolbar button)
Users are looking for some validation to be performed when someone has updated the sheet and they then try to save and close.
My approach for this type of validation would be to add code into the Workbook_BeforeClose Event.
Is it possible to use a macro from one workbook to insert code into another worrkbook and particular event?
Thanks for any help in advance!
Cheers,
G.
I don't know if this is possible so I thought I would post the question and see if anyone has done anything similar before.
A writing a huge macro with lots of different functions and procedures which will be applied to a basic data.xls sheet. (Macro contained in another workbook which is referenced through toolbar button)
Users are looking for some validation to be performed when someone has updated the sheet and they then try to save and close.
My approach for this type of validation would be to add code into the Workbook_BeforeClose Event.
Is it possible to use a macro from one workbook to insert code into another worrkbook and particular event?
Thanks for any help in advance!
Cheers,
G.