VBA in Excel 2007

Topic

New Reply

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.

Reply | Quote

Replies

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?

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.

Reply | Quote

Not a single comment from the collective wisdom?

Uninstall Office 2007 and reinstall Office 2003?

Reply | Quote

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.

Uninstall Office 2007 and reinstall Office 2003?

Reply | Quote

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?

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

Reply | Quote

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.

Reply | Quote

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.

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.

Reply | Quote