Custom Toolbars

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

Someone provided me with a link to a site where everything I ever wanted to know
about toolbars was available, but alas, I have lost it. If you have the link, I would
appreciate it again. In the mean time, I'm trying to accomplish the following:

Computer "A" has Windows 2000 Professional and Excel 2002.
Computer "B" has Windows XP and Excel 2002.
I have macros assigned to the "Tools" menu on Computer "A".

I am trying to share a custom toolbar from Computer "A" with computer "B".
I thought the toolbar was saved with an XLB extension, but that extension is not on
Computer A or B.

How do I get the custom Toolbar from Computer "A" to Computer "B"?

Is the "Tools" menu considered a Toolbar?

Thanks,
Bernie
 
Hi Bernie,
I should have read the question more completely first.
Yes your toolbars are stored in your *.XLB file and you
only have one that is in use. You do not want to share
that (or force that) on someone else. If you have a lot of
macros that you want to share then perhaps start with
John Walkenbach's Menu Maker. Since you have
mentioned .XLB -- then, of course, it would be a file
that you would want to backup.
http://www.mvps.org/dmcritchie/excel/backup.htm

Back to what I originally was thinking of:

It doesn't have everything I ever wanted to know about toolbars,
but it does have most of what I do know about toolbars (or at least
references to other pages as well, some even also on my site).
Toolbars, Custom Buttons and Menus
http://www.mvps.org/dmcritchie/excel/toolbars.htm

Of course you will find the following in my references but just
to make sure you don't miss them, since you said you had
a web page that you lost track of.

Chip Pearson describes the process of creating a menu.
"Menus In Excel97 And 2000" either manually or in VBA
http://www.cpearson.com/excel/menus.htm
Also look at the thread:
http://google.com/[email protected]

John Walkenbach has Menu Maker, where the use of a
spreadsheet will help you initially to set up a logical arrangement
of your toolbar menus.
Custom Menus in Excel 97 , Tip 53 "Menu Maker" «, John Walkenbach.
http://www.j-walk.com/ss/excel/tips/tip53.htm
I have some notes in my buildtoc.htm concerning sorting the table
used to create the menus.

If you want to document what you have in your toolbars,
kind of the opposite of Menu Maker see,
Barhopper -- ... Listing of Menu Items
http://www.mvps.org/dmcritchie/excel/barhopper.htm

Another way of doing this would be to have an Addin, that has it's
own toolbar. Keeps users ignorant of making better use of Excel,
while increasing your own skills (sometimes call job security).
 
Wow David, Lots of information! I promise not to lose it this time.
I really appreciate all that you have provided here, and your effort to make it available
to me and other readers.

Thanks so much,
Bernie
 
Back
Top