Hi,

I am making a simple VBA macro to send a Workbook as an email when a button is clicked.

The method that i have found is activeworkbook.hasroutingslip = True.

When using this code, Excel Asks the user if they wish to allow the programme to send. If you click yes, it runs a quick timer whilst setting it up, and then asks again if you wish to send.

If you click NO at anytime, rather than just stopping the process, it crashes.

Is there any way around this process, which is long and unefficient, or is there a way to put some Error handling somewhere so that it does not need debugging everytime someone says no.

Anybody who could point me in the right direction? It would be much appreciated.

Thanks

Phil