Excel control idMsos of Excel 2010
Hi all
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.
http://www.rondebruin.nl/files/RDB_Built-in_idMso’s_Excel_2010.zip
You can also find the download link on this page
http://www.rondebruin.nl/ribbon.htm
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.
Thanks
Ron de Bruin
http://www.rondebruin.nl/tips.htm
2010?! IT just got everyone at the office up and running on 2007 not more than two months ago. Nothing like current events…