View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ludo Ludo is offline
external usenet poster
 
Posts: 74
Default 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