Hi
This one is a whole lot better and funnier though. Click A1, Data, datavalid
and then click userdefined. Write 9 and the go to the last option and write
for instance: "Ooops, you are not allowed to enter a digit above 9." A little
grey window will pop up with that messaage whenever you write a number above
9 in A1. I love this myself.
Hope you can use it.
--
Therese


"BiggieD" skrev:


Hi. I have 3 questions to ask.

1. Is there a formula i can use which will make a cell show exactly the
same as what another cell shows on a different page?

2. Is it possible to put a timer on certain cells so they close within
--mins and --hours?

3. Can i enter a formula into a cell which stops people from going over
a certain number?

If anybody can help it would be much appriciated.

Many thanks,
Nathan.


--
BiggieD
------------------------------------------------------------------------
BiggieD's Profile: http://www.excelforum.com/member.php...o&userid=33607
View this thread: http://www.excelforum.com/showthread...hreadid=533869