Excel VBA Email confirmation with hyperlink

I'm a newbie and I'm stuck. I have a shared workbook on a network drive. I need an email sent out every time a change is made and the sheet is saved. I would like the email to contain a link to open the sheet. The link would be gotten from the Excel sheet itself say from cell A1. The text appears as plain text in the body of the email instead of a clickable link.

Please Login or Register  to view this content.

Any help would be greatly appreciated!

Tony C