Hi friends,
Can anybody help me out in ceating custome toolbar in excel. i have made various macros but wanted to link throgh custome toolbar..
Thanks
suhas
Hi friends,
Can anybody help me out in ceating custome toolbar in excel. i have made various macros but wanted to link throgh custome toolbar..
Thanks
suhas
Good morning suhas.nehete
Welcome to the forum!
Tools > Customise
Select New under the Toolbars tab
Choose a name and click OK. You Now have a blank toolbar
Go to the Commands tab and drag the icons from the window on the right into your toolbar
Right click on an icon in your toolbar and select Assign Macro
By right clicking you can also edit the image
When you close the customise box the toolbar will be active
You may also find the thread below of use, but if you are going to share these macros with other users you should look at creating a toolbar on-the-fly with some code.
http://www.excelforum.com/showthread.php?t=598861
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks