I have a macro which is assigned to a control box or button. However I do not
want the macro to run if a value is entered in another cell in the worksheet.
Eg

if Cell A1 has a drop down list and if "Apply Mannually" is chosen then the
macro should not run if teh user accidentally presses the control box button

How can I do this
--
Kav

Private Sub commandButton1_Click()
if Range("A1").Value = "Apply Manually" then exit sub

' current code

End Sub

--
Regards,
Tom Ogilvy


"Kav" wrote:

I have a macro which is assigned to a control box or button. However I do not
want the macro to run if a value is entered in another cell in the worksheet.
Eg

if Cell A1 has a drop down list and if "Apply Mannually" is chosen then the
macro should not run if teh user accidentally presses the control box button

How can I do this
--
Kav