Posted to microsoft.public.excel.programming

SmartyPants SmartyPants is offline

external usenet poster

Posts: 26

Cell Restrictions still

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RESTRICTIONS	YESHWANT JOSHI	Excel Discussion (Misc queries)	5	May 26th 09 05:02 PM
Cell Restrictions	SmartyPants	Excel Programming	6	September 22nd 06 09:35 PM
Cell Restrictions	SmartyPants	Excel Programming	1	September 22nd 06 06:39 PM
How to do look up with restrictions	JackR	Excel Discussion (Misc queries)	3	April 3rd 06 01:12 AM
Excel Cell Restrictions	sandy.cariappa	Excel Worksheet Functions	1	May 27th 05 11:10 AM

All times are GMT +1. The time now is 11:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us