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…
Hello Mr Bruin
I have been forced to learn all these Techy things in order to get back what I had when I had my XP. I just am thankful there a sites such as this. I am only trying make 1 custom tab, the panning hand ….I have always had it & then all of a sudden its gone. I am using Excel 2010 on win7 x64 & do have touch screen….but no luck with anything or anyone. Until I found you. Everything I did just wasn’t sticking. I have been searching for weeks, with no resolve.
Your site is awesome !!! U definetly have the answers I’ve been searching for & I see cleaning up bugs along the way too…. very impressive. I really do like techy stuff just do not have time so busy trying to launch my own company & build my own website. Plus work all day with my other company & blah blah blah…anyway.
My question is, where do I add …..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.
& 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 ………..& this yikes.
Also maybe you can tell me which steps I can leave out, if any…. Don’t need a group…just 1 tab that has full 360 degree action & panning hand pic… which was 401 on the ribboon. Now the action & & the hiding is a lil tricky but I have faith this will resolve. I would like to scrap ALL the different I have mande these past weeks but not sure if I should until I get the final goal met…I do not know if you are even a person who could or would help me with thin tab delema.I have the codebut not sure how to pasteiissue.n u tell me how to 401 & but I hadn’t applied the patches since I