auto-filter image
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 |
auto-filter image
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 |
auto-filter image
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 |
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 |
All times are GMT +1. The time now is 07:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com