Thread: Can you run a macro on a worksheet from a module in an XLA?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trefor Trefor is offline
external usenet poster
  
Posts: 201
Default Can you run a macro on a worksheet from a module in an XLA?
I have some code on a worksheet in an .XLS which uses a .XLA with some more
VBA code in it. Is it possible for a macro in the .XLA to run another macro
in the .XLS sheet?

What would the syntax be something like? (which does not work of course)

workbooks("Main.XLS").sheet1.mymacro
--
Trefor
Reply With QuoteReply With Quote