Run VBA code before sheet is send via EnvelopeVisible

[Elorosto]

Hi folks.

My question is regarding VBA function: ActiveWorkbook.EnvelopeVisible = True

As you probably know, this makes it possible to send a mail directly from Excel when the Send sheet button is pressed.
link to a picture of the button I am talking about: https://imgur.com/LrYSi17

This has been working great at my working place, as it is simple, it only sends the selected in the current sheet and you do not have to switch to outlook.
The only issue is, I have not been able to find a way to run a code right after the Send sheet button is pressed.

Do you know if it is possible to run a code just after the button is pressed, before the sheet is actually send?

Thanks.

 

[ranman256]

most likely no, since this is an internal excel button. Not a custom one.

 

[Elorosto]

Really? That is too bad. I thought there was a way to interrupt Outlook, before it sends.

But thank you for the quick reply.