Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
VBA Fun
 
Posts: n/a
Default Toolbars Created in Excel 2002 not available in 2003

I have not been able to get a toolbar created in Excell 2002 to be visible in
Excel 2003.

I have copied the excel10.xlb file to the appropriate location.

I have attemped to follow Help instructions (IE open .xlb file). I have
even attempted to simply rename the Excel10.xlb file to Excel11.xlb. In any
scenario, it does not appear upon opening Excel, nor is it listed as an
option to activate(make it visible) from the list of toolbars.

I appreciate any suggestions.

----VBA Fun
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Open excel 2003.
Tools|customize|and create a new toolbar
close excel

windows start button|search
look for that *.xlb you just updated/created.
(remember to look in hidden folders, too)

Make a note of the name and folder location.

Copy your old version to this folder.
Delete the "temporary" *.xlb you just created.
rename the old version to the new name.

Start excel and see what happens.

I'd also delete any other *.xlb files I found in other folders, too.

===
But you may want to take the time to manually create that toolbar. It might
give you a reason to look through all the new things(?) that were added between
2002 and 2003.

VBA Fun wrote:

I have not been able to get a toolbar created in Excell 2002 to be visible in
Excel 2003.

I have copied the excel10.xlb file to the appropriate location.

I have attemped to follow Help instructions (IE open .xlb file). I have
even attempted to simply rename the Excel10.xlb file to Excel11.xlb. In any
scenario, it does not appear upon opening Excel, nor is it listed as an
option to activate(make it visible) from the list of toolbars.

I appreciate any suggestions.

----VBA Fun


--

Dave Peterson
  #3   Report Post  
VBA Fun
 
Posts: n/a
Default

Thanks for the feedback. Unfortuantely it did not solve my problem. I had
placed the excel10.xlb file in the folder C:\Documents and
Settings\xxxxxxx\Application Data\Microsoft\Excel. When I open Excel and
look to select one of the toolbars created in Excel 2002 on a different
computer, the toolbars are not listed as a available to select.

I then proceeded to create a new toolbar and exit Excel. I then looked at
the excel10.xlb file and saw that the date had been updated. So I assume I'm
looking at the correct file...but there was/is no sign of the original
toolbars.

Any further suggestions?

Thanks in advance
--
VBA Fun


"Dave Peterson" wrote:

Open excel 2003.
Tools|customize|and create a new toolbar
close excel

windows start button|search
look for that *.xlb you just updated/created.
(remember to look in hidden folders, too)

Make a note of the name and folder location.

Copy your old version to this folder.
Delete the "temporary" *.xlb you just created.
rename the old version to the new name.

Start excel and see what happens.

I'd also delete any other *.xlb files I found in other folders, too.

===
But you may want to take the time to manually create that toolbar. It might
give you a reason to look through all the new things(?) that were added between
2002 and 2003.

VBA Fun wrote:

I have not been able to get a toolbar created in Excell 2002 to be visible in
Excel 2003.

I have copied the excel10.xlb file to the appropriate location.

I have attemped to follow Help instructions (IE open .xlb file). I have
even attempted to simply rename the Excel10.xlb file to Excel11.xlb. In any
scenario, it does not appear upon opening Excel, nor is it listed as an
option to activate(make it visible) from the list of toolbars.

I appreciate any suggestions.

----VBA Fun


--

Dave Peterson

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

I'd still move all the *.xlb files to a different folder. Then create the new
one and use that location/name for the new name of the old *.xlb file.

VBA Fun wrote:

Thanks for the feedback. Unfortuantely it did not solve my problem. I had
placed the excel10.xlb file in the folder C:\Documents and
Settings\xxxxxxx\Application Data\Microsoft\Excel. When I open Excel and
look to select one of the toolbars created in Excel 2002 on a different
computer, the toolbars are not listed as a available to select.

I then proceeded to create a new toolbar and exit Excel. I then looked at
the excel10.xlb file and saw that the date had been updated. So I assume I'm
looking at the correct file...but there was/is no sign of the original
toolbars.

Any further suggestions?

Thanks in advance
--
VBA Fun

"Dave Peterson" wrote:

Open excel 2003.
Tools|customize|and create a new toolbar
close excel

windows start button|search
look for that *.xlb you just updated/created.
(remember to look in hidden folders, too)

Make a note of the name and folder location.

Copy your old version to this folder.
Delete the "temporary" *.xlb you just created.
rename the old version to the new name.

Start excel and see what happens.

I'd also delete any other *.xlb files I found in other folders, too.

===
But you may want to take the time to manually create that toolbar. It might
give you a reason to look through all the new things(?) that were added between
2002 and 2003.

VBA Fun wrote:

I have not been able to get a toolbar created in Excell 2002 to be visible in
Excel 2003.

I have copied the excel10.xlb file to the appropriate location.

I have attemped to follow Help instructions (IE open .xlb file). I have
even attempted to simply rename the Excel10.xlb file to Excel11.xlb. In any
scenario, it does not appear upon opening Excel, nor is it listed as an
option to activate(make it visible) from the list of toolbars.

I appreciate any suggestions.

----VBA Fun


--

Dave Peterson


--

Dave Peterson
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
Excel 2002 Add-in: Open Database Connectivity available for Excel Nick B Excel Discussion (Misc queries) 8 December 7th 06 06:04 PM
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM
Excel 2000 to Excel 2002 problem Dave the slaphead Excel Discussion (Misc queries) 3 February 17th 05 06:17 PM
Excel 2002 crashes Veena New Users to Excel 0 February 16th 05 10:29 AM
Excel 2003 back to Excel 2002 Pete Carr Excel Discussion (Misc queries) 3 December 27th 04 08:11 AM


All times are GMT +1. The time now is 07:24 AM.

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"