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

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

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

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

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

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

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