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
|