MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Customized Tool Bars - Moving

Posted by Thomas Venn on January 14, 2000 2:51 PM

Hi all,

I have done a lot of customization with my toolbars.
the situation is that I don't want to re-created and
drag all the icons all over again when I move to my
next job.

Does anyone know how to move the file or VB over to
the new computer and have my toolbar override the
existing toolbar?


Posted by Ivan Moala on January 14, 2000 9:53 PM

Hi Thomass
What you are looking for is the username8.xlb file
where username (if you are on a network) is your
windows or network logon name, eg yours maybe
Vennt8.xlb found in your windows dir or just do a search
for it. Copy this file.
Rename the file, retaining the .xlb extension.

To use a saved configuration again, use the Open command on the File menu to open the renamed toolbars settings file. Microsoft Excel creates a new default toolbars settings file Username8.xlb when you next quit the program.


Posted by Thomas Venn on January 18, 2000 11:14 AM

2 marcos into one

Hi all, I am currently using 2 macro buttons to do 2 different things.
Is there any way for me to combine this into one macro button?
kind of like the "full screen" button, where i press it once, it goes
into full screen, then i press it again, it goes back to normal screen.

Sub Tool_Bars_unhide()
Application.CommandBars("Custom_Tool_bar_1").Visible = True
Application.CommandBars("Custom_Tool_bar_3").Visible = True
End Sub

Sub Tool_Bars_hide()
Application.CommandBars("Custom_Tool_bar_1").Visible = False
Application.CommandBars("Custom_Tool_bar_3").Visible = False
End Sub