| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom toolbars in Excel 2003
I wish to send a spreadsheet to colleagues with a custom toolbar attached.
Is this possible, or do I have to load the toolbar onto individual machines. I can vaguely remember reading that toolbars can be created by vba, that is a possible solution, but as the number of users of this spreadsheet is below 10, it may be quicker to load the spreadsheet onto individual machines using a memory stick. -- Thanks in advance, Jill C |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom toolbars in Excel 2003
you can have it built through code easily, I build it on workbook open and
destroy on close, here is some sample, change the on action part to be the name of your function/sub that pressing the button will run Set myBar = Application.CommandBars.Add("Grocery", msoBarTop, , False) Application.CommandBars("Grocery").Controls.Add Type:=msoControlButton, _ ID:=23, Befo=1 Application.CommandBars("Grocery").Controls(1).Cap tion = "Dispatch Summary" Application.CommandBars("Grocery").Controls(1).OnA ction = "GetRoutes" -- -John Please rate when your question is answered to help us and others know what is helpful. "jillc" wrote: I wish to send a spreadsheet to colleagues with a custom toolbar attached. Is this possible, or do I have to load the toolbar onto individual machines. I can vaguely remember reading that toolbars can be created by vba, that is a possible solution, but as the number of users of this spreadsheet is below 10, it may be quicker to load the spreadsheet onto individual machines using a memory stick. -- Thanks in advance, Jill C |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom toolbars in Excel 2003
John, your post was very helpful. Where can I find the list of valid values
for "ID"? -- "John Bundy" wrote: you can have it built through code easily, I build it on workbook open and destroy on close, here is some sample, change the on action part to be the name of your function/sub that pressing the button will run Set myBar = Application.CommandBars.Add("Grocery", msoBarTop, , False) Application.CommandBars("Grocery").Controls.Add Type:=msoControlButton, _ ID:=23, Befo=1 Application.CommandBars("Grocery").Controls(1).Cap tion = "Dispatch Summary" Application.CommandBars("Grocery").Controls(1).OnA ction = "GetRoutes" -- -John Please rate when your question is answered to help us and others know what is helpful. "jillc" wrote: I wish to send a spreadsheet to colleagues with a custom toolbar attached. Is this possible, or do I have to load the toolbar onto individual machines. I can vaguely remember reading that toolbars can be created by vba, that is a possible solution, but as the number of users of this spreadsheet is below 10, it may be quicker to load the spreadsheet onto individual machines using a memory stick. -- Thanks in advance, Jill C |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom toolbars in Excel 2003
http://support.microsoft.com/kb/213552/en-us
List of ID numbers for built-in CommandBar controls in Excel 2000 A general reference on commandbars: http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Exce -- Regards, Tom Ogilvy "jillc" wrote: John, your post was very helpful. Where can I find the list of valid values for "ID"? -- "John Bundy" wrote: you can have it built through code easily, I build it on workbook open and destroy on close, here is some sample, change the on action part to be the name of your function/sub that pressing the button will run Set myBar = Application.CommandBars.Add("Grocery", msoBarTop, , False) Application.CommandBars("Grocery").Controls.Add Type:=msoControlButton, _ ID:=23, Befo=1 Application.CommandBars("Grocery").Controls(1).Cap tion = "Dispatch Summary" Application.CommandBars("Grocery").Controls(1).OnA ction = "GetRoutes" -- -John Please rate when your question is answered to help us and others know what is helpful. "jillc" wrote: I wish to send a spreadsheet to colleagues with a custom toolbar attached. Is this possible, or do I have to load the toolbar onto individual machines. I can vaguely remember reading that toolbars can be created by vba, that is a possible solution, but as the number of users of this spreadsheet is below 10, it may be quicker to load the spreadsheet onto individual machines using a memory stick. -- Thanks in advance, Jill C |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom toolbars in Excel 2003
There is also a nice add-in see
http://www.rondebruin.nl/menuid.htm#Screenshots -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tom Ogilvy" wrote in message ... http://support.microsoft.com/kb/213552/en-us List of ID numbers for built-in CommandBar controls in Excel 2000 A general reference on commandbars: http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Exce -- Regards, Tom Ogilvy "jillc" wrote: John, your post was very helpful. Where can I find the list of valid values for "ID"? -- "John Bundy" wrote: you can have it built through code easily, I build it on workbook open and destroy on close, here is some sample, change the on action part to be the name of your function/sub that pressing the button will run Set myBar = Application.CommandBars.Add("Grocery", msoBarTop, , False) Application.CommandBars("Grocery").Controls.Add Type:=msoControlButton, _ ID:=23, Befo=1 Application.CommandBars("Grocery").Controls(1).Cap tion = "Dispatch Summary" Application.CommandBars("Grocery").Controls(1).OnA ction = "GetRoutes" -- -John Please rate when your question is answered to help us and others know what is helpful. "jillc" wrote: I wish to send a spreadsheet to colleagues with a custom toolbar attached. Is this possible, or do I have to load the toolbar onto individual machines. I can vaguely remember reading that toolbars can be created by vba, that is a possible solution, but as the number of users of this spreadsheet is below 10, it may be quicker to load the spreadsheet onto individual machines using a memory stick. -- Thanks in advance, Jill C |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom toolbars in Excel 2003
Ron,
does erlandsen's site work for you? It hasn't been working for me for at least 2 weeks I believe. How about Laurent Longre's site? http://xcell05.free.fr/english/ Any information on either of these sites? -- Regards, Tom Ogilvy "Ron de Bruin" wrote: There is also a nice add-in see http://www.rondebruin.nl/menuid.htm#Screenshots -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tom Ogilvy" wrote in message ... http://support.microsoft.com/kb/213552/en-us List of ID numbers for built-in CommandBar controls in Excel 2000 A general reference on commandbars: http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Exce -- Regards, Tom Ogilvy "jillc" wrote: John, your post was very helpful. Where can I find the list of valid values for "ID"? -- "John Bundy" wrote: you can have it built through code easily, I build it on workbook open and destroy on close, here is some sample, change the on action part to be the name of your function/sub that pressing the button will run Set myBar = Application.CommandBars.Add("Grocery", msoBarTop, , False) Application.CommandBars("Grocery").Controls.Add Type:=msoControlButton, _ ID:=23, Befo=1 Application.CommandBars("Grocery").Controls(1).Cap tion = "Dispatch Summary" Application.CommandBars("Grocery").Controls(1).OnA ction = "GetRoutes" -- -John Please rate when your question is answered to help us and others know what is helpful. "jillc" wrote: I wish to send a spreadsheet to colleagues with a custom toolbar attached. Is this possible, or do I have to load the toolbar onto individual machines. I can vaguely remember reading that toolbars can be created by vba, that is a possible solution, but as the number of users of this spreadsheet is below 10, it may be quicker to load the spreadsheet onto individual machines using a memory stick. -- Thanks in advance, Jill C |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom toolbars in Excel 2003
Thanks for all your replies, v useful
-- "Ron de Bruin" wrote: There is also a nice add-in see http://www.rondebruin.nl/menuid.htm#Screenshots -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tom Ogilvy" wrote in message ... http://support.microsoft.com/kb/213552/en-us List of ID numbers for built-in CommandBar controls in Excel 2000 A general reference on commandbars: http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Exce -- Regards, Tom Ogilvy "jillc" wrote: John, your post was very helpful. Where can I find the list of valid values for "ID"? -- "John Bundy" wrote: you can have it built through code easily, I build it on workbook open and destroy on close, here is some sample, change the on action part to be the name of your function/sub that pressing the button will run Set myBar = Application.CommandBars.Add("Grocery", msoBarTop, , False) Application.CommandBars("Grocery").Controls.Add Type:=msoControlButton, _ ID:=23, Befo=1 Application.CommandBars("Grocery").Controls(1).Cap tion = "Dispatch Summary" Application.CommandBars("Grocery").Controls(1).OnA ction = "GetRoutes" -- -John Please rate when your question is answered to help us and others know what is helpful. "jillc" wrote: I wish to send a spreadsheet to colleagues with a custom toolbar attached. Is this possible, or do I have to load the toolbar onto individual machines. I can vaguely remember reading that toolbars can be created by vba, that is a possible solution, but as the number of users of this spreadsheet is below 10, it may be quicker to load the spreadsheet onto individual machines using a memory stick. -- Thanks in advance, Jill C |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do we get 2003 .xlb toolbars and custom macros to show in 07 | Excel Discussion (Misc queries) | |||
| Custom Excel Toolbars - how? | Excel Discussion (Misc queries) | |||
| I keep loosing my custom toolbars in Excel 2003. | Excel Discussion (Misc queries) | |||
| Saving Custom Toolbars in Excel 2003 | Setting up and Configuration of Excel | |||
| Getting Excel 2003 to save Custom Toolbars | Excel Discussion (Misc queries) | |||
Hybrid Mode
