Need help adding a custom toolbar to Excel 1

[SBendBuckeye]

Hello,

I need to add a custom button to a tool bar. There are 2 possible actions based on this button, the default which is used almost all the time and a once a year reset. I would like to set up a button similar to the pen and background color toolbars or the New item in Outlook. In other words, if you just click it you get the default action, but I need it to have the little downward arrow so that if you click the arrow it runs the once a year reset action.

I think you can copy buttons and change their properties to make them custom, but I'm not sure where to start. If someone would point me or post a bit of code to get me started, I wuould greatly appreciate it!

Have a great day!

j2consulting@yahoo.com

 

[DanWorrall]

1. In Excel Goto Tools>Customize...
2. Click on the 'Toolbars' Tab
3. Click New.., Enter a Name and Click OK
4. Your new toolbar should appear as a grey box.
5. Next Click on the Commands Tab
6. Scroll Down the listbox on the Left, until you get to macros, click it once
7. two items should appear in thebox to the right, drag the smiley face one (new button) onto your new toolbar. And another for the reset thingy.
8.Right click on these buttons whilst the customize box is still open to do some cool things (Change picture, assign macro) to those butons.
9. Close the customize box and your toolbars are ready!!

 

[SBendBuckeye]

Thanks, Dan! I'll give that a try. Happy New Year!

Once I have defined it, how do I then access its properties if I need to change something? Where did you find the documentation for your list? Very helpful post, enjoy your star! Now go do something else on New Years Day besides hang out on tek-tips ;-)

Have a great day!

j2consulting@yahoo.com