Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sharing Toolbar Buttons
Hi, (this is my first post)
I've created some macros in Word and have created custom toolbar buttons to run them, and I've shared this code with others. How can I share copies of these custom buttons I have created? Many thanks, Tom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sharing Toolbar Buttons
hi,
open a blank xl book. right click any toolbar. from the pop up select customize. select the icon(button) on the tool bar and on the customize box, click modify selection. from the pop up, click copy button image. Paste it in the blank xl book. paste the icons(buttons) maby 2-3 rows apart in column A. In column B, next to the icon, type a brief discription and what macro they are to be attached to. you can now distribute your icons via email. On the other end, your users would have to reverse the above process. they would have to add the custom button from the maco commands in the customize dialog box. copy the icon from the xl file, modify selection, paste button image then assign the macro. hope this helps. Regards FSt1 "tombeek" wrote: Hi, (this is my first post) I've created some macros in Word and have created custom toolbar buttons to run them, and I've shared this code with others. How can I share copies of these custom buttons I have created? Many thanks, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing worksheet with a customer toolbar | Excel Worksheet Functions | |||
Sharing a toolbar | Excel Discussion (Misc queries) | |||
Toolbar buttons | Excel Discussion (Misc queries) | |||
Sharing macros and buttons that accompany the macro | Excel Discussion (Misc queries) | |||
Toolbar Buttons | Excel Discussion (Misc queries) |