code for changing sheet on double click???

[Sonican]

I need excel to switch to Sheet2 whenever I double click in column one. Also I'm new to this, I already have a macro running for the A column that already activates whenever a cell in column A is activated.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)Cancel = TrueTarget.Copy Destination:=Sheets("Sheet2").Range("B2")End Sub

If it is possible to combine the copypaste and change sheet command, that would be great, if not I assume I can just paste the command for the change sheet command below the copypaste command.

(sorry I'm very new to this)</div>

 

[Sonican]

sorry the code is messed in the op here is it a bit more organised

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.Copy Destination:=Sheets("Sheet2").Range("B2")
End Sub