auto-filter image

[jane]

I turned Auto-filter OFF but the Auto-filter drop-down arrow image remains in
random columns. The AUto-filter does not function because Auto-filter is
turned off and that is fine but I need to get rid of the drop-down arrow
images.

any ideas????

thanks in advance! jane

 

[ryguy7272]

Click the '1' on the upper-left hand side of your screen (entire row is
selected). Then click Data > Filter > AutoFilter. This will uncheck the
AutoFilter.

Regards,
Ryan--

 

[jane]

I did that to turn Auto-filter off but the drop-down arrow image remains.

 

[ryguy7272]

Can you right-click on one of those arrows to select it? You may be looking
at objects. Run this code (found it on another post) to delete all 'objects'
on your sheet:

Sub DeleteObjects()
Dim nType As Long
Dim shp As Shape

For Each shp In ActiveSheet.Shapes
nType = shp.Type
Select Case nType
Case msoChart, msoTextBox
' inlcude "or anything else for that matter" not to delete
Case Else
shp.Delete
End Select
Next
End Sub


Regards,
Ryan---