I have a button in excel that emails the sheet to me, I have got this to
work. But I have one question:
Does the workbook have to be open in order to mail it? Cant we mail a closed
workbook?

I know workbook has to be open if we want to update it, is it the same for
email it too?

Thanks in advance