Hi, I currently have an Excel book then when a button is pressed the vb
behind it saves the book and then emails it via Outlook.

My problem is the company firewall prevents it being sent. Can't change the
firewall rules, hence is there a way around it, i.e.

disable or delete the vb during the save?

or do I need rather than save the book to save the relevant sheet to another
book - don't know the syntax

????