Link to home
Create AccountLog in
Avatar of route217
route217Flag for United Kingdom of Great Britain and Northern Ireland

asked on

click email address hyperlink and attached open excel file

Hi Experts using excel 2007

is it possible when you click a hyperlink of a persons name, which is the email address to at the same time attach a copy of the open and current excel file to the email...you are about to send.
Avatar of Ken Butters
Ken Butters
Flag of United States of America image

Is the hyperlink in an excel worksheet?

If so you can use the following worksheet function:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
End Sub

Open in new window

Avatar of route217

ASKER

Excellent feedback let me test...

and yes it is an excel 2007 workbook...
Hi buttersk

just tried vba in the worksheet function and its not adding an workbook attachment...
ASKER CERTIFIED SOLUTION
Avatar of Ken Butters
Ken Butters
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Hi bittersk

any thought on the worksheet function....
Excellent ignore my previous email..buttersk