Hi All,

I have been trying to get my hyperlinks to work properly.

I have two sheets. The first called Consolidation, has hyperlinks which I have created to open up the second sheet Worksheets. On the worksheets sheet, there are 19 "blast sheets". (A form that the user enters data into daily). The hyperlink works just fine, but I want the ActiveCell to open the blast sheets at the top left hand corner.

I have the formula in VBA that I need to put in, but I don't know where exactly to put it????? I have opened the VBA to put it in, but don't know why firstly, the code won't work and secondly WHERE does it go???

Code is
Sub Macro35()
ActiveWindow.ScrollColumn = ActiveCell.Column
' ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollRow = ActiveCell.Row
End Sub


Please PLEASE can someone assist?????