View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BRC BRC is offline
external usenet poster
 
Posts: 10
Default running a macro on another worksheet

I have a workbook with several sheets. when i enter values into
certain cells on WS1 i want each sheet to run a macro to analyze those
values. For instance; in WS2 I have a macro that fills in a table on
ws2. In WS3 there is a macro that fills in a table on WS3 etc. I am not
sure if I should be trying to run the macros on their specific sheets
or put them in a module and somehow code the output to the respective
sheets. I have a command button on sheet to start the process. Any
suggestions would be appreciated. thanks, BRC