HI,
I have been trying to use a "Private Sub" to start a Macro when I select a specific worksheet with in the workbook. But I am having trouble with the syntax. Not sure if I should be using WorkSheet_SelectionChange or WorkBook_sheetchange.
Here are a couple of variations that i have tried but no luck
Private Sub Worksheet_selectionChange(ByVal target As Excel.Sheet)
If target.Address = "Reconciliation" Then Call Recon
End Sub
And
Private Sub Workbook_Changesheet(ByVal target As Excel.Sheet)
If target.Address = "Reconciliation" Then Call Recon
End Sub
Any help would be greatly appreciated
Thanks
Cliff
I have been trying to use a "Private Sub" to start a Macro when I select a specific worksheet with in the workbook. But I am having trouble with the syntax. Not sure if I should be using WorkSheet_SelectionChange or WorkBook_sheetchange.
Here are a couple of variations that i have tried but no luck
Private Sub Worksheet_selectionChange(ByVal target As Excel.Sheet)
If target.Address = "Reconciliation" Then Call Recon
End Sub
And
Private Sub Workbook_Changesheet(ByVal target As Excel.Sheet)
If target.Address = "Reconciliation" Then Call Recon
End Sub
Any help would be greatly appreciated
Thanks
Cliff