[John Smith]

I would like the users to be able to run a macro but not from the
menu bar. Is it possible for users to click a cell to run a macro?
If not, what's the closest thing to it? Thanks.

[Snake Plissken[_2_]]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Address() = "$A$1" Then

Call "myMacro"

End If


End Sub

[Snake Plissken[_2_]]

| 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