Hi,

I have a workbook in which workbook_beforesave sub is run. The file doesnt
save if there is some internal data inconsistency. ( For example a
particular column is supposed to have only inetegers so if something else is
entered the file will not save).

I notice that once I enter data in it and do a "Save as" instead of save the
beforee save sub still works to my satisfaction.

But, suppose I enter some gibberish data and use the "Send to mail
recepientnt as attachment" then excel saves a temporary file ( having
inconsistent data) and attaches it to my Lotus Notes 5.

I just wanted to understand why this happens.

Also, is there any way may prevent this ( If it doesnt involve
elaborate/abtruse coding I will be greatful to include it as a part of the
existing code.)

Regards,
Hari
India