Save last position of spreadsheet

[Nigel]

I have a workbook with a main worksheet containing around 300 rows. each row has an individual hyperlink to a separate worksheet in the same workbook. The problem is if I use any of the hyperlinks, when I return to the main sheet (via another hyperlink), it defaults to the top of the spreadsheet and I have to scroll down to find my previous position. Is it possible to get excel to "remember" its previous position on the main worksheet?

Regards

[Richard Buttrey]

Hi,

If you're clicking on a hyperlink to return to the main sheet, its that hyperlink that is presumably linked to cell A1 on the Mastersheet. If you just reselect the main worksheet tab without clicking any hyperlinks you should end up back at the original active cell.

The other thing you could do is use the worksheet DeActivate and Activate events with a couple of lines of VBA code to
a) record the position of the active cell address in a spare cell when you leave the main sheet and
b) return to that address when the main sheet is Activated.

HTH