can i use VBA in one XLS file to change VBA in another?
hi all:
i have a bunch of XLS files that have VBA code in them that have
already been sent out to another consultant (all are hospital
specific) and i was notified earleir today that a "button" on one tab
does not work
i verified that it does not work (had forgot to update the assigned
macro to reflect new tab names)
so ... i was hoping to send out a very simple XLS file w/ just one
macro inside it ... and have the other consultant simply call that
macro from within each of the hospital specific XLS file to change the
undering macro to make the button work as designed
can i do that? .... am at a loss so far (i've done other "fix" XLS
files, but those changes were always to the workbooks proper, changing
formulas, etc.
thanks in advance
|