Change Macro Start

[MGumbrell]

I have a Macro that starts when Ctrl+Shift+C is pressed.

I would also like this macro to start when the user clicks Range("S18") on ("Sheet1")

Can you please advise me.

Regards, Matt

 

[chergh]

use the selection change event:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
If Sh.Name = "Sheet1" And Target.Address = "$S$18" Then
Call macro_name
End If

End Sub

 

[MGumbrell]

Thank you

I will give that a try.

Regards, Matt