+ Reply to Thread
Results 1 to 4 of 4

Clobbered CommandBar Names

  1. #1
    Registered User
    Join Date
    01-07-2008
    Posts
    34

    Clobbered CommandBar Names

    I think I have messed up my Excel application and cannot figure out how to undo or correct it.

    I'm running Excel 2011 on OS X High Sierra (10.13.6) on a late 2012 Mac Pro.

    Here's the symptoms:
    • - All of the VBE commandbars (toolbars) except the first 4 have lost the first character of their names. For example, "Object Browser" toolbar name appears as "bject Browser". Here's the code to produce the listing and the results:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    • - Probable cause: in attempting to learn how to create a toolbar for the VBA commands I use the most, I first wrote a routine which restored the "Edit" toolbar to default, then another to modify the "Edit" toolbar to delete the controls I didn't want and then copy the controls I wanted from the "Standard" and "Debug" bars. I played with that for a while till I got it where I wanted it. Then I created my own custom toolbar and copied all the desired controls to it. I'm not sure when the commandbars lost their first characters, but now that's what I see.
    • - In an attempt to repair the damaged commandbars, I have uninstalled and re-installed MS Office three times. I have AppCleaner installed and it offered me the option of deleting a number of application support files, which I accepted. It has made no difference. This, of course, means AppCleaner has not cleaned up everything.
    • - After uninstallation, I scanned /Library and /User/Chuck/Library for any files that remained that had "Excel" in the filename and didn't find anything that looked like it was the culprit (I examined them with Hex Fiend to see if anything jumped out at me, be nothing got my attention.
    • - I took my application to another instance of Excel 2011 under Parallels 15.1.4 (El Capitan v.10.11.6) and the names of all the commandbars were correct, so it's clear to me that I've clobbered one/some critical Excel files.
    • - Short of completely reinstalling the operating system, is there anyway to correct the problem Excel/Office file(s)? Alternately, is it really a problem? Will the pop-ups, context menus, shortcuts work anyway?
    Thanks for your help,
    Chuck

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,656

    Re: Clobbered CommandBar Names

    Have you tried resetting the commandbars

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-07-2008
    Posts
    34

    Re: Clobbered CommandBar Names

    Thanks, Andy.

    That had no effect on any of the commandbars. (I tried to post the debug prints, but security blocked it as a SQL insertion.)

    Chuck

  4. #4
    Registered User
    Join Date
    01-07-2008
    Posts
    34

    Re: Clobbered CommandBar Names

    Well, some good news: it turns out that, while the toolbars' names might be fouled up, the toolbars themselves still seem to function properly. I guess I can live with that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. CommandBar Problem
    By CaptMac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2012, 08:50 PM
  2. Display commandbar as add-in
    By jeffreybrown in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2011, 02:22 PM
  3. CommandBar
    By gabch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2007, 02:44 PM
  4. Tag in CommandBar
    By Desert Piranha in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2006, 01:34 AM
  5. Add Commandbar when Add-in is install
    By A.Q in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2005, 04:10 PM
  6. [SOLVED] cant dim as commandbar
    By Seren in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2005, 05:20 PM
  7. CommandBar
    By swiederkehr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-19-2005, 12:05 PM
  8. [SOLVED] commandbar problems
    By Richard Cook in forum Excel General
    Replies: 1
    Last Post: 07-08-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1