Forum Discussion
How to remove a Drop Down Box
Thanks. It is a so-called ActiveX combo box.
Make sure that you see the Developer tab of the ribbon. If not:
- Select File > Options.
- Select 'Customize Ribbon' in the navigation pane on the left.
- Tick the check box Developer in the list of Main Tabs on the right.
- Click OK.
Activate the Developer tab of the ribbon.
In the Controls group, click to highlight Design Mode.
You can now select the combo box by clicking on it.
Press Delete to remove it.
Don't forget to turn off Design Mode again.
Could you create a copy of the workbook, remove everything except the dropdown box, then save the copy and attach it to a reply?
Thanks for your reply: see attachment
Thanks. It is a so-called ActiveX combo box.
Make sure that you see the Developer tab of the ribbon. If not:
- Select File > Options.
- Select 'Customize Ribbon' in the navigation pane on the left.
- Tick the check box Developer in the list of Main Tabs on the right.
- Click OK.
Activate the Developer tab of the ribbon.
In the Controls group, click to highlight Design Mode.
You can now select the combo box by clicking on it.
Press Delete to remove it.
Don't forget to turn off Design Mode again.
- The best, simplest solution. Thanks
Outstanding; I was able to remove the Drop Down Box. After deleting the Drop Down Box, currently unable to remove the outline box in relation to Drop Down Box that was deleted without deleting the number text which I need. Please advise
Could you attach a sample workbook demonstrating the problem?
- That did it. 🙂
Thank you.
(Your directions were clear and complete, you made it easy....good job).
