ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating a toolbar using VBA (https://www.excelbanter.com/excel-programming/284185-creating-toolbar-using-vba.html)

Phill

Creating a toolbar using VBA
 
I have created an add-in that contains some VBA sub-
routines. I have the Open and Close events turning on
and off the custom toolbar. My question is, is there a
way to build the toolbar in code if it doesn't alreay
exist. Thanks

John Wilson

Creating a toolbar using VBA
 
Phill,

John Walkenback has an example and some code to
build a toolbar on-the-fly.

Take a look he
http://j-walk.com/ss/excel/tips/tip90.htm

John

"Phill" wrote in message
...
I have created an add-in that contains some VBA sub-
routines. I have the Open and Close events turning on
and off the custom toolbar. My question is, is there a
way to build the toolbar in code if it doesn't alreay
exist. Thanks





All times are GMT +1. The time now is 09:46 AM.

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