ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sharing Toolbar Buttons (https://www.excelbanter.com/excel-discussion-misc-queries/140233-sharing-toolbar-buttons.html)

tombeek

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


FSt1

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




All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com