Thread: Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Myriam Myriam is offline
external usenet poster
 
Posts: 97
Default Validation

Hi,
I'm validating a cell, using Name range, I have 5 items and a blank. I
don't know if I'm trying to do something that Excel won't allow.

I need users to select from the given items, without being able to override
those items, but at the same time I need a blank for users to add a new item
if necessary. Is this possible?
As always, any light you can give me is highly appreciated.
Thanks.
Regards,