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!
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!