Removing "Send this Sheet" heading from Excel

[Bob Benjamin]

How do I remove the "Send This Sheet" from my Excel WorkBook?

 

[Don Guillett]

Sub clearsendto()
ThisWorkbook.EnvelopeVisible = False
End Sub

 

[Otto Moehrbach]

Don
What/where is this "Send this sheet" that is referred to? I thought it
might mean the "Send To" that is in the File menu but it doesn't remove
that. Thanks for your help. Otto

 

[Don Guillett]

With xl2002, when you send an email, sometimes the send to is left. This
removes that.

 

[Bob Benjamin]

Don,

The send this sheet is like part of the tool bar that would allow you to
e-mail the spreadsheet.
It has a To entry box for the addressee, a cc box and a Subject of the
message box.

REgards, BobB

 

[Bob Benjamin]

Thanks Don for the solution.

Sub clearsendto()
ThisWorkbook.EnvelopeVisible = False
End Sub

 

[Don Guillett]

glad to help

 

[Otto Moehrbach]

Thanks Don. I have not ever sent an email out of Excel so that is new to
me. Otto