Hey Doug,

I found a solution that works! It turned out to be very easy. Instea
of trying to complicate things by detecting when a new sheet was adde
and how, I just decided to have the combobox refresh every time tha
sheet with the combobox (call it sheet2) was opened.

I figured if a sheet gets copied or inserted, the selected sheet wil
change away from sheet2. When they activate sheet2, the combobox wil
then have the new sheet included.

Works like a charm. Thanks for all the help Doug

--
Message posted from http://www.ExcelForum.com