You mean like have the button call the macro
Private Sub CommandButton1_Click()
Call Macro1
End Su

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