ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom Buttons (https://www.excelbanter.com/excel-programming/293217-custom-buttons.html)

Erik[_6_]

Custom Buttons
 
Sorry for the empty post. Finger went to the wrong key

I have a macro assigned to a custom button in the toolbar, but it is only available on the computer I first set it up on. Is there a way to attach that setting to the file for transportation and use on different computers?

Tom Ogilvy

Custom Buttons
 
If the button is on a custom toolbar you can attach it to the file with the
macro.

Tools=Customize=toolbars tab, click Attach

Select you custom toolbar and move it to the right side.

Now, if someone opens this file and they don't already have a toolbar with
that name, your toolbar will be created.

--
Regards,
Tom Ogilvy

"Erik" wrote in message
...
Sorry for the empty post. Finger went to the wrong key.

I have a macro assigned to a custom button in the toolbar, but it is only

available on the computer I first set it up on. Is there a way to attach
that setting to the file for transportation and use on different computers?



Erik[_6_]

Custom Buttons
 
Tom
Thanks. Works great.


All times are GMT +1. The time now is 12:40 PM.

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