Disable the sort commands in autofilter (Excel 2010)

L

Ludo

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
 
Top