I can open a workbook from a hyperlink on a webpage, but I want to have
several links which will open specific worksheets within the workbook. Can I
do this and if so, how do I specify the sheet?
I can open a workbook from a hyperlink on a webpage, but I want to have
several links which will open specific worksheets within the workbook. Can I
do this and if so, how do I specify the sheet?
Insert named ranges, and then add #NamedRange to the end of the hyperlink.
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy
www.OfficeArticles.com
"AndrewMead" <[email protected]> wrote in message
news:[email protected]...
> I can open a workbook from a hyperlink on a webpage, but I want to have
> several links which will open specific worksheets within the workbook. Can
I
> do this and if so, how do I specify the sheet?
I don't speak HTML, but maybe:
<a href="file://c:/yourfolder/book1.xls#'sheet 1'!A1">click me</a>
AndrewMead wrote:
>
> I can open a workbook from a hyperlink on a webpage, but I want to have
> several links which will open specific worksheets within the workbook. Can I
> do this and if so, how do I specify the sheet?
--
Dave Peterson
I'll try it!
Thanks to both replies
"Dave Peterson" wrote:
> I don't speak HTML, but maybe:
>
> <a href="file://c:/yourfolder/book1.xls#'sheet 1'!A1">click me</a>
>
>
>
>
>
> AndrewMead wrote:
> >
> > I can open a workbook from a hyperlink on a webpage, but I want to have
> > several links which will open specific worksheets within the workbook. Can I
> > do this and if so, how do I specify the sheet?
>
> --
>
> Dave Peterson
>
Thanks to both responses - they both work!
Andrew
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks