View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William W. Viergever William W. Viergever is offline
external usenet poster
 
Posts: 3
Default 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