Hi
I want to create a button on the toolbar that is linked to a macro.
I also want to customize the button with a "smiley"
How can I do this?
Thanks
supermario
Hi
I want to create a button on the toolbar that is linked to a macro.
I also want to customize the button with a "smiley"
How can I do this?
Thanks
supermario
Have the workbook with the macro that you wish to attach to the button open
Tools Menu > Options > Commands
Under the Categories list find Macros
Click on Custom Button Icon, Whilst hoding down left mouse button drag icon upto the tool bar
Right click on new toolbar Icon, Select Assign Macro
Select required macro from presented list
When right clicking on Icon you also get options to Change, edit Icon
I hope this helps you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks