Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Macro Toolbar?
I have a spreadsheet that has several macros attached to buttons on the
sheet. It is likely that I'll need to put even more macros in, but the buttons are beginning to clutter the sheet and, besides, are just more objects that could create problems should other users want to customize the format. Is it possible to build a custom toolbar with all the macros as selections on it? Importantly, it would need to be something that opens automatically with the workbook and then goes away when the workbook is closed so that users wouldn't need to access/close it separately. (Chaos would ensure if they had to deal with this thing separately.) Is there a way to do this with VBA? Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Macro Toolbar?
See
http://www.rondebruin.nl/menuid.htm#articles Look at John's page for a great example -- Regards Ron de Bruin http://www.rondebruin.nl "Wuddus" wrote in message ... I have a spreadsheet that has several macros attached to buttons on the sheet. It is likely that I'll need to put even more macros in, but the buttons are beginning to clutter the sheet and, besides, are just more objects that could create problems should other users want to customize the format. Is it possible to build a custom toolbar with all the macros as selections on it? Importantly, it would need to be something that opens automatically with the workbook and then goes away when the workbook is closed so that users wouldn't need to access/close it separately. (Chaos would ensure if they had to deal with this thing separately.) Is there a way to do this with VBA? Thanks in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Macro Toolbar?
Wow--this looks pretty comprehensive. Nice page! I'll start investigating
immediately. Thanks! "Ron de Bruin" wrote: See http://www.rondebruin.nl/menuid.htm#articles Look at John's page for a great example -- Regards Ron de Bruin http://www.rondebruin.nl "Wuddus" wrote in message ... I have a spreadsheet that has several macros attached to buttons on the sheet. It is likely that I'll need to put even more macros in, but the buttons are beginning to clutter the sheet and, besides, are just more objects that could create problems should other users want to customize the format. Is it possible to build a custom toolbar with all the macros as selections on it? Importantly, it would need to be something that opens automatically with the workbook and then goes away when the workbook is closed so that users wouldn't need to access/close it separately. (Chaos would ensure if they had to deal with this thing separately.) Is there a way to do this with VBA? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom toolbar looses buttons when closed | Setting up and Configuration of Excel | |||
How would I move/insert a custom picture (button) onto the toolbar | Excel Discussion (Misc queries) | |||
macro assignments on toolbar go to 'save as' file | Excel Discussion (Misc queries) | |||
Custom toolbar and macros | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |