View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Snake Plissken[_2_] Snake Plissken[_2_] is offline
external usenet poster
 
Posts: 75
Default Is this possible? Click a cell to run a macro



| Private Sub Worksheet_SelectionChange(ByVal Target As Range)
|
| If Target.Address() = "$A$1" Then
|
| Call "myMacro"
|
| End If
|
|
| End Sub
|
|
1. the code above should be put in sheet area in VBA editor

2. of course "myMacro" is the name of a macro so write it without quotation
marks