View original (French)

Remove Excel dropdown list

Solved
SamAlex Posted messages 9 Status Membre -  
 b@bd -
Hello,

I have done several tests to create a dropdown list in my workbook, and there is one that I am not able to delete. I can't select it (even with the right-click) to delete it like I did with all the others I created. It's really annoying because I have finished my invoice (thanks to your help), and this pesky list keeps showing up and even prints out!! My workbook and sheet are unlocked... I can't even move it or delete a row for it to disappear at the same time. Thank you for your precious help!!<code>Configuration: Windows XP
Office 2007

3 réponses

Réponse 1 / 3
m@rina Posted messages 27174 Registration date   Status Modérateur Last intervention   11 541
 
Hello,

I suppose it's an ActiveX control.
To select and delete it, you need to be in Design mode.
Display the "Controls Toolbox" toolbar, enable Design mode (the first button on the toolbar), and delete your list.

m@rina
13
SamAlex Posted messages 9 Status Membre 12
 
It's exactly what you thought. Thank you once again! You are incredibly efficient!!
0
fred
 
I confirm the incredible effectiveness. My problem is also solved
Thank you
0
b@bd
 
Thank you
0