How do I remove a combo box in Excel 2007

H

Harry Flashman

I have excel 2003 at work and I inserted a combo box (I think that is
what it is called) with a drop down menu. I am at home now using a
computer with Excel 2007 and I want to remove this Combo Box, but I
can't find the tool bar (control box?) that I used to create/edit it.
This is quite frustrating. Can anyone tell me where it is please? I
want to remove this box.
 
D

Dave Peterson

You have to show the developer's tab on the ribbon.

That's under the office button|excel options.
It's a checkbox in the top section of the Popular category.

Then look in the Developer's group on the ribbon.

Then you'll be able to find the "toolbar".

But if you used a combobox from the control toolbox toolbar, you'll have to go
into design mode (another icon in that group).

Then select the combobox and delete it.

Then toggle the design mode icon again to leave that mode.
 
H

Harry Flashman

You have to show the developer's tab on the ribbon.

That's under the office button|excel options.
It's a checkbox in the top section of the Popular category.

Then look in the Developer's group on the ribbon.  

Then you'll be able to find the "toolbar".

But if you used a combobox from the control toolbox toolbar, you'll have to go
into design mode (another icon in that group).

Then select the combobox and delete it.  

Then toggle the design mode icon again to leave that mode.
Click to expand...

Thanks very much Dave.
 
Top