| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get rid of a drop down box exported from a worksheet?
I exported data from another worksheet into excel from specific sortware.
Graphics came with the data. All the other ones I could delete but I could not delete a drop down box. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get rid of a drop down box exported from a worksheet?
try
sub noshapes() ActiveSheet.DrawingObjects.Delete end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "EW" wrote in message ... I exported data from another worksheet into excel from specific sortware. Graphics came with the data. All the other ones I could delete but I could not delete a drop down box. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get rid of a drop down box exported from a worksheet?
Hi,
Did you try Ctrl + G Special Objects. This will select all objects including drop down boxes. Now simply hit the delete button. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "EW" wrote in message ... I exported data from another worksheet into excel from specific sortware. Graphics came with the data. All the other ones I could delete but I could not delete a drop down box. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with graph from exported information | Charts and Charting in Excel | |||
| Some columns exported from Access do not sum | Excel Discussion (Misc queries) | |||
| An XML mapping cannot be exported | New Users to Excel | |||
| Drop-down data not appearing in exported XML | Excel Discussion (Misc queries) | |||
| Formating exported data | Excel Worksheet Functions | |||
Linear Mode
