re : Possible to run private sub macros by writing another private

re : Possible to run private sub macros by writing another private

Post by ZGRpaWN » Sat, 27 Aug 2005 10:15:03


Hi all,

I have 7 private subs ... all linked to indiviudal command button.
7 Private sub listed below :-

1) LGC01
2) LGC02
3) LGC03
4) LGC04
5) LGC05
6) LGC06
7) LGC07

I want to write another PRIVATE sub to run all the private subs LGC01, 02,
03, 04 ,05 ,06 and 07 together ... can it be done???
 
 
 

re : Possible to run private sub macros by writing another private

Post by c2ViYXN0aW » Sat, 27 Aug 2005 11:46:06


Hi,
Assuming these subs have no parameters:
Sub RunAll()
LGC01
LGC02
LGC03
LGC04
LGC05
LGC06
LGC07
End Sub
--
Regards,
Sbastien
< http://www.yqcomputer.com/ >

 
 
 

re : Possible to run private sub macros by writing another private

Post by T-x » Sat, 27 Aug 2005 12:42:46


Yes you can, if all 7 and the new private subs are located in the same
module...

ddiicc Wrote:


--
T-x
------------------------------------------------------------------------
T-x's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/
 
 
 

re : Possible to run private sub macros by writing another private

Post by T-x » Sat, 27 Aug 2005 12:49:52


You can write something like:

Private Sub RunAllThree()
AllModelsLGC011stAndFinalPass_Click
AllModelsLGC021stAndFinalPass_Click
AllModelsLGC031stAndFinalPass_Click
End Sub

That is, if you're only interested in executing the codes in the
subs... :)

ddiicc Wrote: