View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default auto-filter image

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---



--
RyGuy


"jane" wrote:

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

"ryguy7272" wrote:

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--





--
RyGuy


"jane" wrote:

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