I have a macro that opens automatically, runs a couple of calculations and is
programmed to email the completed workbook at the end. I want a way to
disable the macro when i send it so when it is opened by the recipients, the
macro does not automatically start again.

Thanks,

Chris