vba - Run macro on another worksheet from one sheet Excel -
i have 2 excel workbooks (wb1, wb2). want able run macro wb1 run macro on wb2. macro want run on wb2 in wb2. want click button run wb2 macro on wb2.
you can use application.run
run macro on different workbook. assuming wb2
open, , macro want run called macroname
can use following ...
application.run "wb2!macroname"
from within wb1
Comments
Post a Comment