BeforeSend event / Before Send event - Can anybody help me?

[antaeusguy]

Hi

I've a macro file which is a request form.

I've programmed it in the BeforeSave event so that User cannot save if mandatory fields are incomplete before e-mailing to me.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
'This event will trigger a incompleteness check
(Codes goes here)
End Sub

However, I found User was able to bypass this check and I received incomplete forms.

I doubled checked my code and I wasn't able to save if I've incomplete information, i.e. mandatory fields are not filled in.

I asked the User how does she bypass it, and she says she goes to File > Save & Send > Send using e-mail > Send as attachment and Excel did not perform the check!

I was nervous when I found out about this loop hole...

Does anyone knows how to prevent this from happening?

 

[diddi]

if you set your form up on a userform, you could manage your problem more easily i would think.