LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Turn of Autofilter Arrows?

Hi All........
Anyone know if it's possible to programmatically turn off the DownArrows on
the display while leaving the Autofilter in it's filtered state?.....
I would like for my user to see only the Autofiltered results, and not be
aware that they can reorder them with the downarrows.
Otherwise, can I call my autofilter with code, then freeze it so the
downarrows do not work manually until I release them with more code.

TIA
Vaya con Dios,
Chuck, CABGx3




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ensuring Autofilter arrows are visible at end of macro robs3131 Excel Programming 2 July 2nd 07 01:08 AM
AutoFilter list arrows won't respond Romans Excel Worksheet Functions 0 February 17th 07 11:42 PM
red autofilter arrows instead of blue in Excel? Trader D Excel Discussion (Misc queries) 1 August 28th 06 04:36 AM
IF AutoFilter is on, turn it off CLR Excel Programming 14 April 21st 05 03:26 PM
Invisible AutoFilter Drop-Down Arrows Brian Arnold Excel Programming 3 July 30th 04 07:51 PM


All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"