what does the VBA screen say? (assume you mean it give you an error message).

Also, what version of excel are you using.

--
Regards,
Tom Ogilvy


"max" wrote:

I've inserted a command button and recorded (very simple):

Private Sub CommandButton2_Click()

Range("F9").Select
With Selection.Interior
.ColorIndex = 43
.Pattern = xlSolid
End With
End Sub

When I click the button, it takes me to the VBA screen. what am I doing
wrong?