Setting a required cell
In the code behind the button, check that the cell is not empty
If IsEmpty(Range("C1).Value) Then
'error
Else
'send it
End If
--
HTH
Bob Phillips
"wjd01" wrote in message
...
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.
|