Think Bob showed you how to properly structure your code and address Sheet2
from the Sheet1 code module so you don't have to pursue the "Bandaid"
approach you have come up with.



--
Regards,
Tom Ogilvy


"BlonTMamba" wrote
in message ...

hey

thanks all for replying!!!

alltough that was not exacly what i meant :) i learnd some new things
tho

and I just found the function i meant :) i will show you:

i put the routine for command button 2 (wich i called CB2) in
ThisWorkbook.
than i put the following code for the command button in sheet1:

Private Sub CommandButton2_Click()
Call [ThisWorkbook].CB2
End Sub

that was probally to easy for you to think of i just started
working with excel like this :)

thanks again

greets


--
BlonTMamba
------------------------------------------------------------------------
BlonTMamba's Profile:
http://www.excelforum.com/member.php...o&userid=30774
View this thread: http://www.excelforum.com/showthread...hreadid=504411