Excel macro activation.
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 |
All times are GMT +1. The time now is 02:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com