Many thanks Joel, I'm going to try it.
--
Regards!
Stefi
€˛joel€¯ ezt Ć*rta:
you need to have a macro for each button but the macros can call a
common subroutine located in a module
place in a vba sheet
Private Sub CommandButton1_Click()
Call Commonbutton(ActiveSheet)
End Sub
Place in a moudle
Sub Commonbutton(Sht as Variant)
end Sub
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160217
Microsoft Office Help
.