Required Sheet and fields

[ralphdevlin via OfficeKB.com]

First, I'm not that familiar with programming in excel, but at our company,
we need certain cells in excel filled out so we know that it has been
completed and not missed. What we want to do is have one sheet in our
spreadsheet that has a check box that says is an existing user been migrated
to this computer. If the box is checked then we want the second sheet to
become required on all fields and must be populated. We are using Excel 2003..
Thanks.

 

[dok112]

you want a If Then statement...

Sub Test()

If Checkbox1.Value = True Then
'code to use if checkbox is checked...
Else:
'code to use if checkbox is unchecked...
End If
End Sub

 

[Ronald Dodge]

This is one of the issues of Excel as there is no real good way to enforce
this as the only way to truely enforce this would be to set such code within
the workbook's BeforeSave Event, which means the user would be forced to
fill out these cells before the workbook can be saved. With a true DB
environment, this sort of requirement is relatively easy to accomplish, but
in a Spreadsheet environment, you must ask yourself this question:

Which is more important, enforcing this requirement, and take the chance of
having to redo every single bit of work that was done to it before it could
possibly be saved, and have something like a power outage take place to only
wipe out every bit of that work that was done, but yet, couldn't be saved
until such requirement was fulfilled, OR is it more economical to allow them
to save their work in process without having to redo such a large chunk, if
something like a power outage was to take place?

We have a similar type situation, but I choose not to enforce it cause of
the latter issue. There's other things that we have in place that kicks it
back out to the required personnel to do their part before it can move on.