Gotcha.

Thank you again for everything.

Otto Moehrbach wrote:
No, I don't think that can be done. You can have a "global" macro in your
Personal.xls workbook that can be accessed by any other workbook, but not an
event macro like I gave you. You can put the meat of the macro I gave you
in the Personal.xls workbook, but you would still have to have an event
macro in each "TA" workbook to pick up on a change to R13 and call that
macro, so that wouldn't help you. Sorry. Otto
Global as in:

[quoted text clipped - 20 lines]

Any assistance would be greatly approached. Thank you.

--
Message posted via http://www.officekb.com