ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Link in Outlook to an excel worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/41957-link-outlook-excel-worksheet.html)

SA330

Link in Outlook to an excel worksheet
 
I would like to no how to create a link in an outlook email to a worksheet in
an excel workbook.

Equivilent to Insert/file as hyperlink

However, I want the path to specify the worksheet name so the paticular
worksheet will be activated when the workbook is opened.

Any help would be appreciated..

HiArt


Hi,

you could write a simple Auto_Open macro to select the sheet you want.
There's plenty of help on Auto_Open macros on exceltip.com or via a
google search.

Art


--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=398478



All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com