Good evening

Put a piece of code like this in the buttons event procedu

Sub MyActions()
If Checkbox1=True Then
' Put your action in here
End If
End Sub

As long as this goes in the buttons event procedure control, the
checkbox (in this case 1) will not be read until you click the button.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=346107