Command bar controls not working!

Hi.
I have added code to add 2 command bar controls which in turn have sub
controls running seperate macros. The problem is that the command bar contols do not appear on workbook open, which they should do, and have done in the past? Please any suggestions! Thanks.

Please Login or Register  to view this content.

Hello cheelie,

Excel Toolbar File

Occasionally, the toolbar file for Excel can become corrupted. If this occurs, you may experience problems when you start Excel. In this situation, locate the toolbar file and rename it. After you rename the toolbar file, Excel rebuilds a new toolbar file the next time you start Excel.

For example, if your toolbar file name is JoeUser8.xlb, rename the file to JoeUser8.old. Then, start Excel, and notice that Excel creates a new JoeUser8.xlb file in the same location as the original toolbar file.

For additional information about the Excel toolbar file and how to identify it, click the following article numbers to view the articles in the Microsoft Knowledge Base:
291074 (http://support.microsoft.com/kb/291074/) XL2002: Default toolbars and toolbar buttons seen instead of customizations
For additional information about another toolbar problem when you start Excel, click the following article number to view the article in the Microsoft Knowledge Base:
215366 (http://support.microsoft.com/kb/215366/) XL2000: Page fault starting Excel with Page Break menu command
Excel.pip File

Excel remembers what menus and commands have been used and displays these most recently used menus first. Excel hides the unused commands in its expandable menus. Excel stores this usage data along with menu animation settings in a file named Excel.pip.

This file can become corrupted. If this occurs, you may experience problems when you start Excel. In this situation, locate the Excel.pip file and rename it. After you rename the file, Excel rebuilds a new .pip file the next time you start Excel. Use the Windows search feature to locate the Excel.pip file.

Sincerely,
Leith Ross

Hi Leith

Thanks for your prompt reply.
I've tried your suggestions but I'm still having the same problem. I have a similar excel file which contains custom menus. If I open the file with the problem no custom menus are visible, however, when I open the similar excel file instead of having 2 additional custom menus visible, which are created in my code for this workbook, I get 4; the 2 from this workbook and the 2 from the problem workbook!
It would seem there is something fundamentally wrong with the workbook!?

Hope U can help!
Thanks

Hello Cheelie,

It sounds like the problem may be with Excel. You set the custom menu up as a temporary menu. Excel should destroy it when it closes and recreate it when you open the workbook. Multiple copies indicates that is not happening.

Try this...
1) Open a new Excel workbook (blank)
2) On the Taskbar Click on Start > Run...
3) Type excel /unregserver
4) Excel will close itself automatically
5) Open a a new Excel workbook (blank)
6) On the Taskbar Click on Start > Run...
7) Type excel /regserver

Reopen the the problem workbook. Hopefilly this will fix it.

Sincerely,
Leith Ross

I had hidden 2 sheets in the workbook, after unhiding them the toolbar menus now appear when opening the workbook. I don't know enough about VBA to know if this is right? There is no reference to the hidden sheets in the code which creates the toolbar menus, however, the macros which they in turn run do refernce to these hidden sheets....a little confused!!

Hello Cheelie,

Your custom menu was added to the Worksheet Menu Bar which is visible regardless which worksheet you have selected or hidden. So, I don't understand either why that would have any effect.

Sincerely,
Leith Ross