Putting macros on a toolbar
I have Office XP and in Word I have macros on the toolbar. I go to customise
toolbar and select commands and then macros, I then see the macros listed and I can drag them to the toolbar. But when I do this in Excel the macros are not listed, just 'Custom menu item' and 'Custom button'. How do I get the macros? Thanks Dudley |
Putting macros on a toolbar
drag the icon to the toolbar.
rightclick on the icon (with that tools|customize dialog visible) and choose assign macro. When I want to create a toolbar, I do it via code: 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) It makes life much easier when the files are renamed/relocated/shared with others. Dudley wrote: I have Office XP and in Word I have macros on the toolbar. I go to customise toolbar and select commands and then macros, I then see the macros listed and I can drag them to the toolbar. But when I do this in Excel the macros are not listed, just 'Custom menu item' and 'Custom button'. How do I get the macros? Thanks Dudley -- Dave Peterson |
Putting macros on a toolbar
Thanks. That solves the problem. I don't know why they have to make it so
much more complicated than in Word. Dudley "Dave Peterson" wrote: drag the icon to the toolbar. rightclick on the icon (with that tools|customize dialog visible) and choose assign macro. When I want to create a toolbar, I do it via code: 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) It makes life much easier when the files are renamed/relocated/shared with others. Dudley wrote: I have Office XP and in Word I have macros on the toolbar. I go to customise toolbar and select commands and then macros, I then see the macros listed and I can drag them to the toolbar. But when I do this in Excel the macros are not listed, just 'Custom menu item' and 'Custom button'. How do I get the macros? Thanks Dudley -- Dave Peterson |
All times are GMT +1. The time now is 04:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com