From: Meck2003 on
I have tried naming a range in cell A1, but each time it will open to the
last page the file was saved at.

"Stefan B Rusynko" wrote:

> Create a named range in the Excel sheet you want to open
> (in cell A1 or any cell you want to go to)
> - In sheet 5 create a named range as say "startsheet5"
> Then link it as a bookmark using the named range
> workbookname.XLS#startsheet5
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
> _____________________________________________
>
>
> "Deb" <Deb(a)discussions.microsoft.com> wrote in message news:85BFCA4A-2466-403C-AA36-5B06749B2C4D(a)microsoft.com...
> | How do I create a hyperlink into a specific worksheet within an Excel file? I
> | tried using a (#) bookmark referencing the tab name, but each time the Excel
> | file opens it enters into the worksheet where the file was saved.
> | --
> | New user looking for quick answers.
>
>
>