View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
pikus pikus is offline
external usenet poster
 
Posts: 1
Default all macros into one..

Put the code for the macros in to a module and be sure to rename them
and declare them as "Public" exe:

Public Sub NewSub1()
blah blahblah
End Sub

Public Sub NewSub2()
blah blahblah
End Sub

Public Sub NewSub3()
blah blahblah
End Sub

Then create one macro that calls each in turn:

Sub Macro1()
Call NewSub1
Call NewSub2
Call NewSub3
End Sub

- Pikus


---
Message posted from http://www.ExcelForum.com/