You can use the BeforeClose event procedure to do this. In the
ThisWorkbook code module, use something like

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If cells_are_incomplete Then
Cancel = True
End If
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"tschultz " wrote in
message ...
Hi,

Is there a way to force users of a custom form to populate
required
cells? I am currently using a macro button to send form data
by
e-mail. Prior to actual send, the macro verifies the mandatory
cells
are popluated. If not, the blank cell is selected to allow
entry.
This form will be moving to a terminal server in near future
eliminating the need for the send button. I still need to
verify
manadory cells are populated and allow users to enter data
prior to
closing file.

Any suggestions?

Thanks so much
tschultz


---
Message posted from http://www.ExcelForum.com/