Hi,

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

Any suggestions?

Thanks so much
tschult

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