View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Al Jager Al Jager is offline
external usenet poster
 
Posts: 5
Default Macro clipboard problem

Someone please,
Why does this macro not work?
Want to display the Clipboard and send workbook to a
client.

Sub Send_to_Client_1()
'
' Send_Client Macro
' Macro recorded 11/19/2003 by Al Jager
'
Range("B2").Activate 'B2 contains an email address
Selection.Copy
' If Application.DisplayClipboardWindow = True Then
' MsgBox "Office Clipboard can be displayed."
' Else
' MsgBox "Office Clipboard cannot be displayed."
' End If

' ActiveCell.DisplayClipboardWindow 'expression

Application.Dialogs(xlDialogSendMail).Show

End Sub