commandbar problems
 

On My PC with Excel 2000, I have developed an Excel workbook with a custom
command bar. The resulting 'xls' file is in a folder on our network and
available to everyone in our company. When opening this Excel workbook on
other PCs in my office with Excel 2003 or Excel 2000, the custom command bar
is missing some of the controls and appears to be an older version of the one
that shows on my own PC where the command bar was created and where any
modifications are performed. I believe the problem is related to the command
bars being stored locally along with the Excel application as earlier
versions of Excel were (in the [username8.xlb] file). I cannot find any
verification of this theory, and no '*.xlb' type files exist on my Excel 2000
or the other Excel 2003 PCs. Any help?

The best way to create custom toolbars is using VBA.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=14
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Richard Cook" <Richard wrote in message
...
On My PC with Excel 2000, I have developed an Excel workbook with a custom
command bar. The resulting 'xls' file is in a folder on our network and
available to everyone in our company. When opening this Excel workbook on
other PCs in my office with Excel 2003 or Excel 2000, the custom command
bar
is missing some of the controls and appears to be an older version of the
one
that shows on my own PC where the command bar was created and where any
modifications are performed. I believe the problem is related to the
command
bars being stored locally along with the Excel application as earlier
versions of Excel were (in the [username8.xlb] file). I cannot find any
verification of this theory, and no '*.xlb' type files exist on my Excel
2000
or the other Excel 2003 PCs. Any help?