View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Create a Link to a Specific Worksheet

First touch the Insert tab
The touch Hyperlink
Specify to a Place In the Document

and then set the link.
--
Gary''s Student - gsnu200856


"mlenmik" wrote:

I want to be able to create a link to an Excel workbook which worked in older
version of Excel and i was curious if it still works in Excel 2007. I
followed the process below but it did not seem to work.

In the URL line, put your cursor after (workbook).xls and type #(name) where
(name) represents the name you defined in step two. For example, if the
workbook you created was entitled 'Workbook' and the Name you defined in step
two was 'worksheet', the URL line would read:
Workbook.xls#worksheet