Link in Outlook to an excel worksheet

G

Guest

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..
 
H

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
google search.

Ar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top