Macro to run another macro if the header of the selected column = "Name"

[tonywatsonhelp]

Hi Everyone,

I need a macro that can run another macro if the change is made in that column?

So I have a sheet and in Row 11 I have headers,
so if I type in any cell above row 11 do nothing,
if i type something select a drop down or paste something in a row lower than row 11 then if the column i made that change in has a header in row 11 that = "Name"
then call New Name, if not do nothing.

please help if you can

Thanks

Tony

 

[bebo021999]

Right click on sheet name, view code
paste below code into edit window:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim subname
If Target.Row <= 11 Then Exit Sub
subname = Cells(11, Target.Column).Value
Application.Run subname
End Sub

ALso, insert new module, paste below code (or using your own code):

Sub Name1()
MsgBox "Hello name1"

End Sub
Sub Name2()
MsgBox "Hello name2"

End Sub

 

[tonywatsonhelp]

Thank you Bebo this is great
Tony