Thread: Add a button to top panel

Hi,

My company uses a special set of colors. We have an addin that is a button in the top panel that is always there when you open excel (more precisely, it is a menu like "Insert" called "Company Addins" with a button on to format charts) that can autoformat a chart (line colors etc) - you click on chart, click on button, voila, done.

The set of colors was recently changed, but the addin hasn't been, and it is nowhere in sight, so i created my own. I have written the needed macro (called "ChartFormat"), saved it as an addin, so whenever i start excel i can make a form control and attach ChartFormat to it, hit the button and voila, done.

But how do i do like the existing one, ie create a top menu and have a button so i don't always need to make a form control button and attach my macro to that? Any solution would work, just as long as i can click a button that is always visible (or a button in a menu that is always visible) that enables you to click the chart, click the button and have chart formatted?

i use excel 2007. a further complication is that i likely cannot add anything to a launcher as my excel is again a company specific version that adds some extra functions...

Go to the option menu and select customize ribbon> and add what ever you want to the ribbon.

No worries, if this problem is solved please mark the thread solved by going to advanced edit.

Thanks