macro - email current page

[Mack Neff]

How can I click a word ("email") in a cell and launch outlook to email the
current worksheet as an attachment to a single, defined email address. I
can't use a control button because the user is blind and his software
doesn't recognize control buttons. It can only recognize content in a cell
and give him the opportunity to act on the content... like <Click>

 

[Mark Ivey]

Here is one possible alternative...

I typed the work "Email" in cell E5 on Sheet1 and set up a macro to run if
that cell is double clicked. See the code below.

'*********************************************************************************
' This is the code to be assigned on Sheet1
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If ActiveCell = Cells(5, 5) Then
MyTestMacro
End If
End Sub
'*********************************************************************************
' The code above will fire the following macro shown below whenever cell
"E5" is double clicked
' This is the code to be assigned to its own module
Sub MyTestMacro()
MsgBox "Hello", vbOKOnly
End Sub
'*********************************************************************************
As for launching Outlook and sending email... you can look on the following
site to get the associated code to assign a similar scenario like I have
shown above (you can use a double click function to fire off a different
macro for doing what you want). Ron DeBruin has a lot of code for doing what
you want with respect to sending mail from Excel.

http://www.rondebruin.nl/sendmail.htm