creating a drop down list of information to choose from

[Katherine]

Subject: Re: drop down lists
From: "Nick Hodge"
<[email protected]> Sent: 8/23/2004
2:10:30 PM



I followed the instructions below - I get the validation
area if I am in a new database with no information - but
in the data base I am working in it isn't an option - can
you tell me how to get it as an option in a active data
base? It is a shared data base - does this matter?

Catherine

This can be done manually but check out Data>Validation...
and the 'list'
option. I think it's what you will need.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Nick Hodge]

Katherine

According to help (XL2003), you can continue to use data validation in a
shared workbook but cannot change or add it once the workbook is shared

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)