Excel macro button Excel 2003

Excel2006

Active Member
Joined
Dec 19, 2006
Messages
455
Hi

I have looked on this site as I need a command bar and macro buttons that will allow me to run some macros.

Thx
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Hi there,

If you right click your existing command bars and select 'Customise', then in the next window on the 'Toolbars' tab click 'New...'. name your toolbar then click OK, this will create you a new blank toolbar. Then on the 'Commands' tab, scroll the first list down to 'Macros' and select it. In the next list there will be a smiley face called 'Custom Button'. Click and drag this to your new toolbar, then right click it and select 'Assign Macro' and select the macro that you want to activate when you click the button (or enter a name and record a new one). Then click close on the Customise or add more custom buttons - you can change the image from a smiley face in the same right-click menu that you select assign macro from.

Cheers
 
Upvote 0
Thx for that, but I meant I need Vba code.

Something like

sub new toolbar

Application.CommandBars.Add

code

end sub
 
Upvote 0

Forum statistics

Threads
1,224,616
Messages
6,179,909
Members
452,949
Latest member
beartooth91

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top