Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning a button to a subroutine
Works like a champ!
Great resource Thanks! Harry-Wishes "Dave Peterson" wrote: Saved from a previous post: Your life will become much simpler if you include code to create the toolbar when the workbook is opened and include code to destroy the toolbar when the workbook is closed. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) In xl2007, those toolbars and menu modifications will show up under the addins. Harry-Wishes wrote: Hello. I created a custom toolbar which contains a single button. No sweat. Now, is there a programmatic way to write a subroutine that can attach this button to another subroutine. Maybe "assign to a suubroutine" is better terminology. I have done an exhaustive hunt on the topic but I come up short. Below, is a snippet of code where I created an object to the toolbar and the button. This is as far as I've been able to go. Dim ctlToggle As Office.CommandBarButton Set ctlToggle = CommandBars("Letter_Toolbar").Controls(1) Help appreciated as always. Harry-Wishes -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling a subroutine with a command button | Excel Programming | |||
Run a subroutine from a worksheet without button, menu, or shortcut key… | Excel Programming | |||
assigning value to option button | Excel Programming | |||
Assigning macro to button | Excel Discussion (Misc queries) | |||
Assigning name to button | Excel Programming |