Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
It's been two weeks since I've heard anything regarding this problem. I
guess I've stumped the experts. "stgislander" wrote: This toolbar was not created by my company. This toolbar and associated macros were created by Village Software and came bundled in Office 2000 when we purchased it. I spoke to the person who setup our small office network and he feels confident that they are written in VBA. I read Debra Dalgleish's site for creating a toolbar through code. When I look at the same workbook in both Excel 2000 and Excel 2003, I see that the exact same Add-Ins are installed. The macros still work. The toolbar just doesn't appear in Excel 2003. I do not have a file named Excel9.xlb residing on my PC. The closest thing I have is the file Excel9.olb. I hope this clarifies things a little more. stgislander "Gord Dibben" wrote: How did you create the custom toolbar? If not through code, the custom toolbar will be found in your Excel9.xlb file where it was originally created. Attaching toolbars to a workbook is not a good idea and can fail as you have found out. To have a custom toolbar available across versions, it is best to create the toolbar through VBA code. See Debra Dalgleish's site for creating a toolbar through code. http://www.contextures.on.ca/xlToolbar02.html Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 13:22:09 -0700, stgislander wrote: I'm hoping someone can help with this problem I have a workbook created in excel 2000 with macros in it and also a custom toolbar. When I open the workbook in excel 2003, the custom toolbar does not appear. When I go to Tools/Customize/Toolbars/Attach Toolbars the name of my toolbar appears in the right hand window (Toolbars in Workbook:), but the left hand window is empty (Custom Toolbars:). My custom toolbar does not appear under View/Toolbars either. How can I get my custom toolbar into excell 2003? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I force a custom Excel Toolbar when starting Excel? | Setting up and Configuration of Excel | |||
Load image from directory for custom toolbar of Excel 2000 | Excel Worksheet Functions | |||
Removing custom toolbar from Excel 2003 | Excel Discussion (Misc queries) | |||
Missing drawing toolbar in Excel 2000 | Excel Discussion (Misc queries) | |||
Can I add a borders toolbar to Excel 2000 like the one in Excel 2. | Excel Discussion (Misc queries) |