Excel macro activation.

P

Pete McCosh

Kate,

you could try using the worksheet change event to trigger
the macro. Something like this should work:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$1" and Target.value = "B" Then
Application.EnableEvents = False
Call KatesMacro()
Application.EnableEvents = True
End If

End Sub

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro converts time entered in column E and F from Indian time to CST( without daylight saving) 1
how to have 2 drop down lists filter rows 2
From Excel to user form 0
Change_Event troubles, no error & no work. 6
Change a great number of words in word files, with a macro as short as possible. 5
Making a macro only work on certain files 2
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Pass condition formatting across worksheets via vba. 0

Top