View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
StumpedAgain StumpedAgain is offline
external usenet poster
 
Posts: 192
Default help with Application.EnvelopeVisible

Perhaps you can assign a boolean variable to a button or to vbYesNo and then
have

Dim YNvariable as boolean

Application.EvnelopeVisable = YNvariable

Just a thought...

" wrote:

Can someone help me how to code Application.EnvelopeVisible = FALSE if
the user decides not to use the email?

Application.EnvelopeVisible = TRUE opens the email headers (To, From,
Subject,etc) but
Application.EnvelopeVisible = FALSE removes the headers but leaves the
space occupied by them.

I want to mimic clicking on the email button in the commandbar.
How is it done?