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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter problem 9
Disable Cut/Copy/Paste in Excel 2010 0
dynamic sort 4
Sort Marco won't work in 2010 5
Autofilter 0,00 doesn't work in MACRO 0
Disable commands for one workbook 3
Autofilter / Sort in VBA doesn't work 2
Autofilter / sort doesn't work in MACRO 0

Top