Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
fick
 
Posts: n/a
Default 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

  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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


  #3   Report Post  
fick
 
Posts: n/a
Default

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

  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

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


  #5   Report Post  
fick
 
Posts: n/a
Default

thanks for the knowledgeable infomation..

fick

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I display a data table in an Excel 2002 chart? Dr. Mark F. Charts and Charting in Excel 3 December 29th 04 04:04 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 03:02 PM
Getting Excel 2003 to save Custom Toolbars MIKE MEDLIN Excel Discussion (Misc queries) 1 December 7th 04 08:33 PM
Excel 2002 vs Outlook 2003 Bill Clark Excel Discussion (Misc queries) 1 December 2nd 04 10:03 PM
Report Manager in Excel 2002 Misha Excel Discussion (Misc queries) 2 November 28th 04 07:59 AM


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"