View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tomas Stroem Tomas Stroem is offline
external usenet poster
 
Posts: 26
Default Call macro in other sheet


I have a Master file containing a macro that opens a number of other
workbooks, collects data and the creates statistics from this retreived data,
work well. Now I need to create some statistics in on of the workbooks that I
open from my Master. In this Slave file I have the macro that I want to run,
but only when the Master is running. How can i call the macro in the Slave
worksheet from the code in the Master macro.

Greatful for all help!

--
Tomas S