ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Mandatory Cell (https://www.excelbanter.com/excel-programming/401237-mandatory-cell.html)

sharmashanu

Mandatory Cell
 
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

Mandatory Cell
 
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...
--
HTH...

Jim Thomlinson


"sharmashanu" wrote:

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



All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com