hello

just a quick question.

How do you return the value of a dropdown form in a sheet?

I'm trying to set up my own print option on a workbook.
The way I would like it to work is by checking each of
the 160 sheets for the value of a dropdown. if it is one
of 5 options it will select it, then check the rest and
so on. My only problem is that I need to find out what
has been chosen on each sheets dropdown and nothing seems
to work.

TIA
greg