Additionally, you could protect the worksheet as well, for contents and
scenarios, but not objects, and then unprotect the worksheet when the
textboxes and checkboxes have been properly populated.


--
Kevin Backmann


"Brian Boguhn" wrote:

They are directly on a spreadsheet.

Brian

"Kevin B" wrote:

Are the text and check boxes on a user form or are they placed directly on a
worksheet?

A user form would give you a greater amount of control.

--
Kevin Backmann


"Brian Boguhn" wrote:

I need some help making fields in Excel required. I'd like to make it so
that before someone can save a spreadsheet and/or e-mail it, all fields are
filled out. Note that these fields are text boxes and check boxes.

I'd appreciate suggestions. Thanks!