ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable the sort commands in autofilter (Excel 2010) (https://www.excelbanter.com/excel-programming/447123-disable-sort-commands-autofilter-excel-2010-a.html)

Ludo

Disable the sort commands in autofilter (Excel 2010)
 
Hi,

i need to disable the sort commands in the 'Sort & Filter' - Filter - Sort A to Z, Sort Z to A & the Sort by Color.

How can this be done?
I thought that i could use something like Commandbars.Findcontrols(ID:= ....).enabled = False, but i can't find the ID of those controls.

Anyone who can help me with this item?

Regards and have a nice weekend.
Ludo


All times are GMT +1. The time now is 08:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com