The following code was kindly provided to me - to allow users to click on merged cell range C9 in the €œScorecard€� worksheet, whereupon they are moved to the €œCustomer€� worksheet, cell A1, and moved to the upper left corner of the screen. I eventually want to make this idea work for 12 merged cell ranges on the €œScorecard€� worksheet, to send users to various other worksheets and target cells

Can someone tell me where/how to insert the code? Tried the €œScorecard€� worksheet code module and a general module but it doesnt respond

Any help would be appreciated
Thanks, Phi

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range
if Target.Address = "$C$9" the
Application.ScreenUpdating = Fals
Sheets("Customer").Selec
Sheets("Customer").Range("A1").Selec
ActiveWindow.Zoom = 6
ActiveWindow.ScrollRow =
ActiveWindow.ScrollColumn =
Application.ScreenUpdating = Tru
End I
End Su