I've inherited an Excel application that has combo boxes imbedded in
worksheet cells. They are NOT validation lists or worksheet controls. No VBA
or macros exist in the application. There are no range names in the
application. I can not find the lists from the combo boxes anywhere in the
workbook. Clicking on a list item appears to change the scroll area. I can
not left or right click into properties while in design mode. What are these
strange objects? How do I "look inside them?" I am looking at a book that
tells me to click on "OptionButton Object|Edit" from the pop-up menu. I can
find no such option.

The "combo box" is an auto filter. Select cells to filter. click
Data/Filter/AutoFilter.

"Pictou" wrote:

> I've inherited an Excel application that has combo boxes imbedded in
> worksheet cells. They are NOT validation lists or worksheet controls. No VBA
> or macros exist in the application. There are no range names in the
> application. I can not find the lists from the combo boxes anywhere in the
> workbook. Clicking on a list item appears to change the scroll area. I can
> not left or right click into properties while in design mode. What are these
> strange objects? How do I "look inside them?" I am looking at a book that
> tells me to click on "OptionButton Object|Edit" from the pop-up menu. I can
> find no such option.