Okay - then perhaps you might be better served to ask in an Excel group if
that is possible.
You may need to create a bookmark for the specific tab in order for this to
work, but, like I said, best to post to an Excel news group where the Excel
experts hang out.
--
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.
After furious head scratching, SA330 asked:
| Hi Milly,
|
| Thanks, however the problem I have is not creating a hyperlink to a
| workbook but rather a specific worksheet with in the workbook, do you
| know how to do that.
|
| Thanks
|
| "Milly Staples [MVP - Outlook]" wrote:
|
|| Version of Outlook/Excel? What is your message editor?
||
|| Try this: If using Word as the message editor, open your excel
|| program to the desired spreadsheet. Enable the web toolbar. Copy
|| the address from the web toolbar and paste it into Word. It should
|| show as a hyperlink. Right click on the hyperlink and select "edit
|| hyperlink" from the context menu (or highlight the link and press
|| Ctrl+K). You can now change what is displayed as the text for the
|| hyperlink by changing the display name.
||
||
|| --Â
|| Milly Staples [MVP - Outlook]
||
|| Post all replies to the group to keep the discussion intact. All
|| unsolicited mail sent to my personal account will be deleted without
|| reading.
||
|| After furious head scratching, SA330 asked:
||
||| How do I create a link in Outlook to an Excel worksheet? I would
||| like the link to be equivalent to using;
|||
||| Insert/File/Insert as Hyperlink (for a workbook)
|||
||| However I would like to include the worksheet name (or something
||| equivalent in the path) so that the link will open to a particular
||| worksheet.
|||
||| Any help would be appreciated.