Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have problem sending spreadsheet email and losing custom toolbar and macros | Excel Discussion (Misc queries) | |||
toolbar macros | Excel Discussion (Misc queries) | |||
toolbar macros that dont change when worksheet is renamed | New Users to Excel | |||
Custom toolbar and macros | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |