Thread
:
commandbar problems
View Single Post
#
2
Anne Troy
Posts: n/a
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?
Reply With Quote