none
How to delete ADD-INS listing in the "Tools menu RRS feed

  • Question

  • Hi

    I deleted a couple of "ADD-Ins" I didn't need anymore "CalcTax" and "cTax"  stored in this directory: "C:\Users\John\AppData\Roaming\Microsoft\AddIns"

    The mistake I made is that they where active and now I can't delete the two menu listed in the "Tools Menu".

    I tried to redo the Add-Ins but it doesn't work.

    I ran the "Remove Control macro" below but no success.

    I checked the Registry for the two Add-Ins but found nothing.

    Below is one of the two Add-Ins macro but not the original one. I deleted them.

    and "No Backup"

    Does anyone know how I can remove the two entries in the "Tools menu.                

    Option Explicit

    Const cTag = "CalcTax "

    Sub Auto_Open()

        RemoveControl

        With Application.CommandBars("Worksheet Menu Bar").Controls("Tools").Controls.Add

            .Caption = "CalcTax"

            .Tag = cTag

            .OnAction = ThisWorkbook.Name & "!CalcTax"

    End With

    End Sub

    Sub Auto_Close()

        RemoveControl

    End Sub

    Private Sub RemoveControl()

    On Error Resume Next

    Application.CommandBars.FindControl(Tag:=cTag).Delete

    End Sub

    Sub start()

    UserForm1.Show 0

    End Sub


    Cimjet



    • Edited by Cimjet Friday, April 17, 2015 12:57 AM
    Friday, April 17, 2015 12:50 AM

Answers

  • Re:  Menubars/menus xl2003 and earlier

    To remove any item from the menus...
    Right-click in the menubar area and choose Customize (a dialog box is displayed).
    Drag the unwanted menu item off of the menu and drop it over the worksheet.
    Close the dialog box.
    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Marked as answer by Cimjet Friday, April 17, 2015 3:22 AM
    • Edited by James Cone Monday, October 31, 2016 6:10 PM
    Friday, April 17, 2015 1:21 AM

All replies

  • Re:  Menubars/menus xl2003 and earlier

    To remove any item from the menus...
    Right-click in the menubar area and choose Customize (a dialog box is displayed).
    Drag the unwanted menu item off of the menu and drop it over the worksheet.
    Close the dialog box.
    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Marked as answer by Cimjet Friday, April 17, 2015 3:22 AM
    • Edited by James Cone Monday, October 31, 2016 6:10 PM
    Friday, April 17, 2015 1:21 AM
  • Thank you James

    Well all these years and right in front of my nose, still learning something new.

    Great, thanks again

    John


    Cimjet

    Friday, April 17, 2015 3:24 AM