Disable Send Mail (1 Viewer)

graviz

Registered User.
Local time
Today, 12:00
Joined
Aug 4, 2009
Messages
167
I have designed a form in excel that I need the user to fill out completely before they either send or save the file. I currently have code (see below) that prevents them from saving it however they're able to email it as an attachment. I've seen many posts on disabling the ribbon however I want to make sure it's also compatible with 2003 (which doesn’t have a ribbon). Any ideas?</SPAN>

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Range("L29").Value = 0 Then
Else
MsgBox "Please fill out the entire form", vbCritical, "Incomplete TSSR"

Cancel = True
End If
End Sub

Thanks!
 

Users who are viewing this thread

Top Bottom