Maybe a useful file if you want to change the Excel 2010 Ribbon?
I add a file to my site with all Excel control idMso’s of Excel 2010 RTM
I add a Advancedfilter to the MS file so it will filter on groups and display a picture of the group.
You can also find the download link on this page
I notice one bug in 2010, maybe you want to test it also ?
For 2010 I have add this line to the Advancedfilter macro(Get_Ribbon_Info) because it delete
the format of the banded rows in a part of the Table when you select the “All (No Filter)”
option again after you make another selection in the dropdown.
.Range(“B12?).Value = .Range(“B12?).Value
The file is working OK in 2007 with and without this line
But in 2010 you need it. This file is working OK now in 2007 and 2010.
Ron de Bruin