Excel 2002 custom toolbars
 

I would like to know where excel stores custom toolbars.. I have erased
all excel files with custom toolbars and then have emailed a excel
program to my computer and have opened it and the custom toolbar is
sill different then the one on the other computer... How do I fix
this???? Thanks

fick

How do you create the customizing?

If by ToolsCustomize and dragging menu items to the worksheet menu bar then
these customizations are saved in your Excel.XLB file and not with the
workbook.

Others won't have access to this *.XLB file so customized menus won't show up.

It will be named Excel10.xlb

You can copy it to your home computer, rename the current Excel0.xlb to
Excel10.old then paste in the new Excel10.xlb.

Note: this will destroy any customizations you may have done to the home
Excel10.xlb version.

One more option..........If you assign macros to a bunch of buttons onto a new
Toolbar, you can attach the Toolbar to the workbook.

Best to create menus "on the fly" with code in the workbook.

The sites below give example code and tips.

Note: some sites say for XL97, but same for 2003

http://support.microsoft.com/default...b;EN-US;830502

http://support.microsoft.com/support.../Q159/6/19.asp

http://support.microsoft.com/support.../Q162/8/78.asp

http://support.microsoft.com/default...EN-US;Q166755&


Gord Dibben Excel MVP

On 10 Dec 2004 10:35:32 -0800, "fick" wrote:

I would like to know where excel stores custom toolbars.. I have erased
all excel files with custom toolbars and then have emailed a excel
program to my computer and have opened it and the custom toolbar is
sill different then the one on the other computer... How do I fix
this???? Thanks

Thanks Gord

I know the best way to fix this problem is by creating custom toolbars
in VBA but how do you link the Macros?????

Thanks fick

fick

Example code from

http://support.microsoft.com/default...EN-US;Q166755&

The .OnAction step runs the macro assigned to that item.

Sub menuItem_Create()
With CommandBars("Worksheet menu bar").Controls("Tools")
.Controls.Add(Type:=msoControlButton, Befo=1).Caption = _
"Custom1"
.Controls("Custom1").OnAction = "Code_Custom1"
End With
End Sub

NOTE: This is the code that runs when you click Custom1.

Sub Code_Custom1()
MsgBox "you clicked Custom1"
End Sub

You may also take a look at John Walkenbach's MENUMAKR.xls for creating menus.

http://j-walk.com/ss/excel/tips/tip53.htm


Gord

On 13 Dec 2004 07:46:09 -0800, "fick" wrote:

Thanks Gord

I know the best way to fix this problem is by creating custom toolbars
in VBA but how do you link the Macros?????

Thanks fick

thanks for the knowledgeable infomation..

fick