View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
norrislaketn norrislaketn is offline
external usenet poster
 
Posts: 14
Default Run a macro within a macro


Thanks for the info. Your solution will run if I step into it. If I run ir
directly from the macro shortcut key it does not run. It acts as if it is
executing the next command before the call is complete. Any other thoughts?

"Jim Thomlinson" wrote:

Something like this..

Sub Macro1()
msgbox "macro1"
call Macro2
exit sub

Sub Macro2()
msgbox "macro2"
exit sub


--
HTH...

Jim Thomlinson


"norrislaketn" wrote:

How can you execute a macro within another macro.

Example: Run macro a in macro b. Cutting and pasting does not seem to work.