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/