ExcelBanter - Cell Restrictions

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Cell Restrictions (https://www.excelbanter.com/excel-programming/373514-cell-restrictions.html)

SmartyPants

Cell Restrictions

I need to find a way to keep users from entering the formula (=TODAY())
in a cell that requires today's date.

Cell validation doesn't work because the formula produces a result
within the accepted range.

Is the anyway to "turn off" formulas in a cell?

Any help would be greatly appreciated.

Tom Ogilvy

Cell Restrictions

See answer in your original thread.

--
Regards,
Tom Ogilvy

"SmartyPants" wrote:

I need to find a way to keep users from entering the formula (=TODAY())
in a cell that requires today's date.

Cell validation doesn't work because the formula produces a result
within the accepted range.

Is the anyway to "turn off" formulas in a cell?

Any help would be greatly appreciated.

All times are GMT +1. The time now is 04:32 AM.