Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / October 2007

Tip: Looking for answers? Try searching our database.

Where is file(s) for toolbars?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Doug Boufford - 18 Oct 2007 17:23 GMT
Computer running Office 2000 stolen. HDD is backed-up with Ghost
New computer is running Office 2003.
In Excel, I have PERSONAL.XLS with numerous macros and toolbar icons for
the macros.
Macros will run in 2003 but toolbar icons do not show up. Under View
Toolbars, my own toolbar (DAB - which has the toolbar icons linked to
the macros) is not listed.
Any hints as to where to go from here???

TIA
Doug
Gord Dibben - 18 Oct 2007 18:02 GMT
Toolbar and menu customizations are stored in your *.xlb file.

For 2000 it would have been excel9.xlb

You could overwrite the new excel11.xlb with the old one but this can cause loss
of functionality in 2003 due to many new menu items and features.

I would suggest you re-create your toolbar or better yet read this from Dave
Peterson

........................................................

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

End Dave post......................................................

Gord Dibben  MS Excel MVP

>Computer running Office 2000 stolen. HDD is backed-up with Ghost
>New computer is running Office 2003.
[quoted text clipped - 7 lines]
>TIA
>Doug
Mary Fetsch - 30 Oct 2007 15:54 GMT
Doug,

I've not used Office 2003, but in my Office 2000, my toolbar macro was
Excel.xlb, and it was stored in C:\Documents and Settings\(my
name)\Application Data\Microsoft\Excel.  I've now got Office 2007, and it
appears that the file is stored in the same place but is called Excel12.xlb.

Mary Fetsch

> Computer running Office 2000 stolen. HDD is backed-up with Ghost
> New computer is running Office 2003.
[quoted text clipped - 7 lines]
> TIA
> Doug
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.