Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts
    A friend recently gave me a SS he created that had some code for making a new menu tree to the right of the HELP menu found in Excel 2003 and earlier. Problem is, Excel 2007 has no such HELP menu item. How can I get it to work? I have attached the file.
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Not a single comment from the collective wisdom? If unable to have the original menu structure... how might I make it useful in Excel 2007?

    [quote name='Don_Sadler' post='780903' date='21-Jun-2009 11:42']A friend recently gave me a SS he created that had some code for making a new menu tree to the right of the HELP menu found in Excel 2003 and earlier. Problem is, Excel 2007 has no such HELP menu item. How can I get it to work? I have attached the file.[/quote]

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='Don_Sadler' post='781087' date='22-Jun-2009 22:53']Not a single comment from the collective wisdom?[/quote]
    Uninstall Office 2007 and reinstall Office 2003?

  4. #4
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts
    LOL - that is one option.

    I was wondering if there is any way (and how to do it) to create command buttons on the spash page of the SS so that I could invoke whatever menu items would have been available on an earlier verion of Excel.

    [quote name='HansV' post='781091' date='22-Jun-2009 14:02']Uninstall Office 2007 and reinstall Office 2003? [/quote]

  5. #5
    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
    [quote name='Don_Sadler' post='781087' date='22-Jun-2009 16:53']Not a single comment from the collective wisdom? If unable to have the original menu structure... how might I make it useful in Excel 2007?[/quote]

    I think the problem is that you will have to wait from someone with XL2007 knowledge to help you since you require an XL2007 solution. Many of us do not use or have XL2007.

    Steve

  6. #6
    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
    If you are ok with the menu items appearing in the AddIns tab in 2007, then you can use the commandbars collection - add a new commandbar and then add your controls to that. Otherwise I think you would need to use a 2007 format file. See Ron de Bruin's site here, for example.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you very much for the information. Based on what you said, I went back and looked and the menu I sought was, indeed, in the Add-Ins menu group on the ribbon so I can use it as intended. I will pass the info on to my friend who created the SS as he does not have Excel 2007.

    [quote name='rory' post='781188' date='23-Jun-2009 03:46']If you are ok with the menu items appearing in the AddIns tab in 2007, then you can use the commandbars collection - add a new commandbar and then add your controls to that. Otherwise I think you would need to use a 2007 format file. See Ron de Bruin's site here, for example.[/quote]

Posting Permissions

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