View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Stone Frank Stone is offline
external usenet poster
 
Posts: 134
Default Calling a macro in another worksheet

A macro on sheet A in for sheet A only. you can try to
move your macro from sheet A to thisworkbook. I think it
will work there.
-----Original Message-----
Hi,

With a macro in an WORKSHEET A, I would like to open
WORKSHEET B, then in the macro in Worksheet A, I would
like to start the macro in worksheet B. Call function
works for the macros in the same worksheet but for
another worksheet what code should I use?



.