tken22
11-29-2009, 09:43 AM
Hello,
I have a add-in tool i've created for office 2000-2003. The tool executes fine in 2007 but it doesn't look nice like the other ribbons. Is there a way to execute the XML code required to create a ribbon in 07+ inside a vba macro. Like the code below:
Private Sub Workbook_Open()
If Application.Version > 11 Then
'Execute new ribbon code
Else
'Execute old menu code
End If
End Sub
Any help is greatly appreciated, this is the 3rd VBA forums I'm posting too and really need to solve this issue. The add-in is available, just google nowexceladdin and it should come up.
Thanks for any help!
I have a add-in tool i've created for office 2000-2003. The tool executes fine in 2007 but it doesn't look nice like the other ribbons. Is there a way to execute the XML code required to create a ribbon in 07+ inside a vba macro. Like the code below:
Private Sub Workbook_Open()
If Application.Version > 11 Then
'Execute new ribbon code
Else
'Execute old menu code
End If
End Sub
Any help is greatly appreciated, this is the 3rd VBA forums I'm posting too and really need to solve this issue. The add-in is available, just google nowexceladdin and it should come up.
Thanks for any help!