ExcelBanter - How do I delete a drop list button

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I delete a drop list button (https://www.excelbanter.com/excel-worksheet-functions/47460-how-do-i-delete-drop-list-button.html)

Challenged

How do I delete a drop list button

An input worksheet referes to a vlookup list on another worksheet. One input
cell has a drop list that shows the vlookup list for selection purposes. I
have deleted the vlookup list but cannot delete the drop button.

Ron de Bruin

Hi Challenged

Select the cell and

See DataValidation

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Challenged" wrote in message ...
An input worksheet referes to a vlookup list on another worksheet. One input
cell has a drop list that shows the vlookup list for selection purposes. I
have deleted the vlookup list but cannot delete the drop button.

All times are GMT +1. The time now is 05:35 PM.