Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Custom Toolbar from Excel 2000 to Excel 2003

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?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Custom Toolbar from Excel 2000 to Excel 2003

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?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Custom Toolbar from Excel 2000 to Excel 2003

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?



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Custom Toolbar from Excel 2000 to Excel 2003

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
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 force a custom Excel Toolbar when starting Excel? Dean E Brown Setting up and Configuration of Excel 1 January 14th 07 08:18 PM
Load image from directory for custom toolbar of Excel 2000 Padam Excel Worksheet Functions 0 August 5th 06 06:33 PM
Removing custom toolbar from Excel 2003 [email protected] Excel Discussion (Misc queries) 0 July 14th 06 05:00 PM
Missing drawing toolbar in Excel 2000 Ken Roberts Excel Discussion (Misc queries) 2 February 14th 06 05:10 PM
Can I add a borders toolbar to Excel 2000 like the one in Excel 2. [email protected] Excel Discussion (Misc queries) 5 January 4th 05 02:58 AM


All times are GMT +1. The time now is 07:19 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"