Unfortunately it didn't work. If a sheet is in a window other than window 1,
buttons don't work at all, no macro is triggered. Pushing action is not
animated like in cases when the button works.
--
Regards!
Stefi
€˛Stefi€¯ ezt Ć*rta:
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
.