Not sure whether I have worded the the subject heading right or not but here
goes but if someone can point me in the right direction I would be very
grateful.

Here goes

I have a workbook with many many sheets but the "main" sheet has hyperlinks
to all the other sheets.

When I save data to, say for argument sake sheet 1 and then save and close
the workbook down, I would like it when opened up again, open "main" rather
than "sheet 1" the point of the last save.

can this be done? If so, how?

Cheers in advance