Data Validation Settings Allow Text length

Enter your limits and create a message to display when the entry is too
long.

Tim

--
Tim Williams
Palo Alto, CA


"cathlinn" wrote in message
...
How can I set a character limit on a column and return an error message
when
someone tries to go over the limit? I tried the prewritten script that
was
recommended by Ronx in the Front Page postings:
7/26/2005 5:58 AM PST
Subject: character counter script http://www.irt.org/script/1539.htm
In: microsoft.public.frontpage.programming
but I'm not much of a programmer and I couldn't translate it into visual
basic and make it work. What I need to do is set a 40 text character
limit
on one column with 300 rows in all spreadsheets in a workbook. Is it
possible to do this? Thanks for any ideas.