Hi Kevin thanks for reply, I have 10 buttons labelled £1, £2 £3 and so on
and then 8 buttons i need to make sure one of the 10 (£)buttons has been
pressed before any of the 8 buttons, hope that makes sense

"Kevin B" wrote:

You can set the enabled property of the second command button to false and in
the code module for the first command button you can use this to activate the
button:

Private Sub CommandButton1_Click()

If Not Me.CommandButton2.Enabled Then
Me.CommandButton2.Enabled = True
End If

End Sub

--
Kevin Backmann


"Mike" wrote:

Hi In my worksheet i have 2 sets of buttons, is there a way of preventing
one set of buttons being used until one of the other set has been pressed
first, maybe a warning message