View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sebastienm sebastienm is offline
external usenet poster
 
Posts: 694
Default re : Possible to run private sub macros by writing another private


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


"ddiicc" wrote:

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???