View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

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?