Incell drop down list

Sadik · Mar 30, 2004

HI All,

I want to get the list of all worksheet tab's name in
another workbook in an Incell dropdown list. Worksheets
get added and deleted. How can I do this?

Thanks for your help.

Regards

Sadik

Frank Kabel · Mar 30, 2004

Hi
one way:
- in your other workbook you have to create a list of all your
worksheet names. See http://www.mvps.org/dmcritchie/excel/buildtoc.htm
for creating such a list

- now you can use 'Data - Validation' accessing this list. How to do
this with a list from another workbook is described at:
http://www.contextures.com/xlDataVal05.html

Sadik · Mar 30, 2004

Thanks Frank.

Sadik

-----Original Message-----
Hi
one way:
- in your other workbook you have to create a list of all your
worksheet names. See http://www.mvps.org/dmcritchie/excel/buildtoc.htm
for creating such a list

- now you can use 'Data - Validation' accessing this list. How to do
this with a list from another workbook is described at:
http://www.contextures.com/xlDataVal05.html

--
Regards
Frank Kabel
Frankfurt, Germany

.