Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2008
    Location
    Fort Worth, Texas, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Use VB6 COM AddIn to disable Office 2007 menu item (Office 2007)

    I need a method to disable the File | Convert menu from Excel and Word using VB6 COM (all our COM units are old and written in VB6). I am looking through the UI customization on Microsoft's MSDN site and haven't located it yet. Just thought I would put a shout out to see if anyone has done this and has a sample snippet.

    Thanks!

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

    Re: Use VB6 COM AddIn to disable Office 2007 menu item (Office 2007)

    Have you checked the pointers starting from here: http://www.rondebruin.nl/ribbon.htm
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Aug 2008
    Location
    Fort Worth, Texas, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use VB6 COM AddIn to disable Office 2007 menu item (Office 2007)

    Thanks for the input. The ExecuteExcel4Macro looks promising, i.e.:

    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"

    However I don't have the ID of the "Convert" menu item, and don't know how to get at the embedded menu items.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Use VB6 COM AddIn to disable Office 2007 menu item (Office 2007)

    Does Jan Karel Pieterse's tool for Office 2003 provide the information you need? See <post:=729,591>post 729,591</post:>.

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

    Re: Use VB6 COM AddIn to disable Office 2007 menu item (Office 2007)

    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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