ExcelBanter

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

Anauna

Custom toolbar buttons
 
Hello,

I have no problems assigning a macro to a custom button on a toolbar.
Everything works fine when I open the file on my PC.

Problem: When I sent the file to a colleague the buttons are no longer
available. The macro is still functional from the keyboard shortcut or
Tools-Macro - etc...

I should be able to figure this out...but I have hit a block.

--
Thank-you and all suggestions are appreciated.

Tom Ogilvy

Custom toolbar buttons
 
Create the button with code:


Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

--
Regards,
Tom Ogilvy



"Anauna" wrote in message
...
Hello,

I have no problems assigning a macro to a custom button on a toolbar.
Everything works fine when I open the file on my PC.

Problem: When I sent the file to a colleague the buttons are no longer
available. The macro is still functional from the keyboard shortcut or
Tools-Macro - etc...

I should be able to figure this out...but I have hit a block.

--
Thank-you and all suggestions are appreciated.




Steve C

Custom toolbar buttons
 
Tom,

I have the same problem as Anauna below, but the link you provide comes up
with "Location Not Found." Can you provide another? Thanks.

Steve C
1/25/06

"Tom Ogilvy" wrote:

Create the button with code:


Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

--
Regards,
Tom Ogilvy



"Anauna" wrote in message
...
Hello,

I have no problems assigning a macro to a custom button on a toolbar.
Everything works fine when I open the file on my PC.

Problem: When I sent the file to a colleague the buttons are no longer
available. The macro is still functional from the keyboard shortcut or
Tools-Macro - etc...

I should be able to figure this out...but I have hit a block.

--
Thank-you and all suggestions are appreciated.






All times are GMT +1. The time now is 06:43 PM.

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