Mandatory Cell

[sharmashanu]

Hi All
Is it possible to make a cell mandatory- without a macro and not allow
the workbook to be saved or emailed as attachment.
Thanks for any help

Shanu

 

[Jim Thomlinson]

Nope... Best you can do is have a warning or message of some sort on the
sheet that disappears when the necessary inputs have been entered. Note that
this quite often just gets the user to enter any old value just to make the
warning go away...