Results 1 to 13 of 13
  1. #1
    Lounger
    Join Date
    Jan 2006
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Menu and Toolbar customization problems (Excel 200

    (Edited by HansV to provide link to post - see <!help=19>Help 19<!/help>)

    Is there any further word on the "ToolBar customizations won't stay (Excel 2000)" thread from 2001?
    <post#=62835>post 62835</post#>

    I'm having similar problems, starting with trying to remove the WOPR "Tools" items that I won't need in Excel (Enveloper, Image Extractor, Task Pane Customizer), and other add-ins appearing or disappearing, but not being able to have all of them at the same time. (E.g., the ASAP Utilities, Jan Pieterse's Name Manager 3.2, the Conditional Sum Wizard, and the Excess Format Cleaner 1.1.)

    I either get:
    The three WOPR deleted Tools menu items return, if I don't do anty othe thread steps.
    - Or -
    If I try the listed advice, the WOPR items are gone, but so are most of the other add-ins, too.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menu and Toolbar customization problems (Excel 200

    I would start (in Excel) looking at Tools, addins and noting all which are checked.

    Then I would uncheck them all and start checking them again one at a time. Each time get out of the tools, addins dialog first (and maybe restart Excel too, to be sure). Write down which combinations are giving unexpected results.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Lounger
    Join Date
    Jan 2006
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menu and Toolbar customization problems (Excel

    The main part of my question is how to remove the three Tools menu WOPR items, which I did not put there in the first place,. nor was given the choice during the installation.

    If they could be removed, then everything else works as it should.

    Do they have some "behind the scenes" magic that makes them persist? (That is why I'm asking in this forum.)

    (What would be nice, if WOPR is in Excel, would be the WOPR WorkBar -- hint, hint.)

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Menu and Toolbar customization problems (Excel

    view - tololbars - customize
    Grab the menu items from the toolbar and drag them off and place them in the sheet where they will "disappear" into the ether.

    Steve

  5. #5
    Lounger
    Join Date
    Jan 2006
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menu and Toolbar customization problems (Excel

    Being in Tools-Customize, then dragging the WOPR items off the Tools menu gets them off for the current session only.
    When I exit and re-start Excel, they are back.

    That's why I was trying the tricks in the old 2001 thread about the matter, with only partial success.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Menu and Toolbar customization problems (Excel

    Checkout Jan Karel <!profile= Pieterse> Pieterse<!/profile>'s article on Startup Problems especially the poiints about add-ins and startup files to try to track down what is adding them.

    Steve

  7. #7
    Lounger
    Join Date
    Jan 2006
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menu and Toolbar customization problems (Excel

    Those are the ideas I was trying out before posting here.

    What I'm trying to say, politely, is that *I* didn't put the WOPR items in the Tools menu, so I don't know what is needed to get them out.

    The "usual" methods don't seem to work -- it is not the normal add-in that I have any control over.

    (And the WOPR install routine didn't present me with a choice if I wanted them in Excel or not.)

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Menu and Toolbar customization problems (Excel

    My thought is that something in your startup is adding it.

    What is this "WOPR install Routine" that you are referring to?

    Steve

  9. #9
    Lounger
    Join Date
    Jan 2006
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menu and Toolbar customization problems (Excel

    The process that happened after I clicked on WOPR2003.exe on the CD.

    It added things like:
    HKCUSoftwareMicrosoftOfficeExcelAddinsEnveloperCOM 03.dsrEnveloperXl
    HKCUSoftwareMicrosoftOfficeExcelAddinsWOPRImageExt ractor03.XlConnect
    HKCUSoftwareMicrosoftOfficeExcelAddinsWOPRTaskPane Customizr03.XlConnect

    And I can see them in Tools-Add-Ins-Automation.

    Meaning that its one of those DLL Server type situations:
    HKCR
    + CLSID
    + TypeLib
    + WOPRImageExtractor03.XlConnect

    The usual startup directories show:

    C:Program FilesMicrosoft OfficeOFFICE11STARTUP - empty

    C:Program FilesMicrosoft OfficeOFFICE11XLSTART -empty

    Cocuments and Settingsrd23Application DataMicrosoftAddIns
    Name Manager.xla
    XSFormatCleaner.xla

    Cocuments and Settingsrd23Application DataMicrosoftExcel
    Excel11.xlb

    Cocuments and Settingsrd23Application DataMicrosoftExcelXLSTART - empty

  10. #10
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Menu and Toolbar customization problems (Excel

    If these are COM add-ins, you should be able to remove them via the 'COM add-ins...' dialog, whcih is not normally visible. Right click one of your menu bars, choose customise, then on the Commands tab, select the Tools menu on the left hand side and then scroll about halfway down the right hand side and drag the 'COM add-ins...' button onto a toolbar, then close to the main Excel window. You should then be able to use this menu option to remove COM add-ins just as you can .xla add-ins.
    HTH.
    Regards,
    Rory

    Microsoft MVP - Excel

  11. #11
    Lounger
    Join Date
    Jan 2006
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menu and Toolbar customization problems (Excel

    The COM Add-Ins dialog box has no "Add-Ins available" listed.

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menu and Toolbar customization problems (Excel

    Then you will need to uninstall the WOPR thing. Check if it is listed in Control panel, add/remove programs.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    Lounger
    Join Date
    Jan 2006
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Menu and Toolbar customization problems (Excel

    There is one entry for WOPR 2003 itself, but not the individual programs, i.e., Word, Excel.

    Trying WOPR's own "Add/Remove WOPR Components" does remove the three items from Excel's Tools menu, though.

Posting Permissions

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