i have the following line in a procedure.
with combobox on sheet1

sheet1.ComboREGISTER.DropDown

it works fine if an item is selected. dropdown menu 'close', but if user
selects sheet2 without selecting an item in combobox ,page2 appears and so
does the dropdownmenu eventhough no combobox exists on sheet2. How can i
"close" dropdown menu on sheet change. This problem only occurs if .dropdown
is used. If user clicks combobox to show menu and then switches page menu
close automatically. Please someone help as other sheets need to be
available (i don't want to hide them)

Sunil