Setting a required cell
 

In the button click event, you can check if the required field is
empty. If it is, you can put up a message, redirect focus to the
field, and then exit the sub.

Kin

On Wed, 20 Aug 2003 08:50:03 -0700, "wjd01" wrotE:

Hello,
I have a workbook that contains three sheets. One of the
sheets is setup as a form that the user will fill out, and
then click a button to send via outlook enclosure. Is it
possible to set a cell on a sheet as "required" (needs
entry) so if the cell is blank, the workbook can not be
mailed?

Thanks.