software

One of my users has created a workbook for recording data in lists using data
validation to make the drop-down lists. She wants to prevent the spreadsheet
from being closed down if certain (other) cells have not been populated with
some text. Is this possible through normal tools without macros? I've been
scratching my head and searching help and this forum without success. We have
just started using XL2003.

only a macro could do that.....
--
paul
remove nospam for email addy!
quot;Jonathanquot; wrote:

gt; One of my users has created a workbook for recording data in lists using data
gt; validation to make the drop-down lists. She wants to prevent the spreadsheet
gt; from being closed down if certain (other) cells have not been populated with
gt; some text. Is this possible through normal tools without macros? I've been
gt; scratching my head and searching help and this forum without success. We have
gt; just started using XL2003.

Thank you for your very fast response Paul--I was afraid that would be the
case!

quot;paulquot; wrote:

gt; only a macro could do that.....
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Jonathanquot; wrote:
gt;
gt; gt; One of my users has created a workbook for recording data in lists using data
gt; gt; validation to make the drop-down lists. She wants to prevent the spreadsheet
gt; gt; from being closed down if certain (other) cells have not been populated with
gt; gt; some text. Is this possible through normal tools without macros? I've been
gt; gt; scratching my head and searching help and this forum without success. We have
gt; gt; just started using XL2003.