This is either one question or two:
As 2 Questions (excel 2000):
1.) How do I create a command button on a worksheet using code and have it run a macro located in a remote code module (.xla) I know the ActiveSheet.OLEObjects.("cmdButton1"
.Object.OnAction = "MacroName" works for macros locally, but is there another version or modification that can be used to run remote code modules?
and/or
2.) How do I copy code modules or forms from a remote source (.xla or .xls) using code? I suppose I could copy a "Module" if it was attached to a worksheet, and all the subroutines and functions were specified as "Public", but is there a way to copy a module or specific subroutine without copying a worksheet?
Thanks!
Rissolo
As 2 Questions (excel 2000):
1.) How do I create a command button on a worksheet using code and have it run a macro located in a remote code module (.xla) I know the ActiveSheet.OLEObjects.("cmdButton1"
.Object.OnAction = "MacroName" works for macros locally, but is there another version or modification that can be used to run remote code modules?and/or
2.) How do I copy code modules or forms from a remote source (.xla or .xls) using code? I suppose I could copy a "Module" if it was attached to a worksheet, and all the subroutines and functions were specified as "Public", but is there a way to copy a module or specific subroutine without copying a worksheet?
Thanks!
Rissolo
