Run a macro from selecting a cell

T

Tony Pleasant

In Excel 2000, I am building a dashboard that will run
several macros, view charts, view data, ect. My question
is when a particular cell is selected (B4) I would like
for it to run a macro "BLSPG".

TFTH,
Tony
 
P

papou

Hi Tony
Right click on your worksheet tab, View code and paste:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$4" Then
BLSPG
End If
End Sub

HTH
Cordially
Pascal
 
Top