"Dave Peterson" wrote:
I like to use an adjacent column and put a formula like:
=if(trim(a1)<"","","<-- Don't leave blank")
I bold it in big red letters.
Ken Stratford wrote:
How do I prevent users of my workbook from making a cell blank? I want them
to be able to edit it so have left it unprotected but I donot want them to
be able to leave it blank. It looks as if the Data Validation command should
do it, but I can't get it to work.
--
Dave Peterson
Thanks Dave - that's a useful way round it..
Ken
|