Custom toolbars in Excel 2003

G

Guest

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.
 
G

Guest

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, Before:=1
Application.CommandBars("Grocery").Controls(1).Caption = "Dispatch
Summary"
Application.CommandBars("Grocery").Controls(1).OnAction = "GetRoutes"
 
G

Guest

John, your post was very helpful. Where can I find the list of valid values
for "ID"?

--
 
R

Ron de Bruin

Hi Tom

I see your reply in Google but not in OE
Both are working for me Tom

*********************************
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom toolbars uninstall/re-install 8
Excel 2007 "Custom Toolbars Button" 2
Custom toolbars for specific files 1
custom view to display specific toolbars 6
Custom Toolbars 2
Toolbars 2
Adding a Custom Command Button to the Excel 2007 Ribbon 1
Custom toolbars in templates 2

Top