PDA

View Full Version : Ribbon Object in xl2007 vs CommandBar Object in xl2003



rangudu_2008
08-04-2010, 09:30 AM
Hi,

I recently migrated to xl2k7 from 2k3. Attached is a menu module which i'd coded in xl2003. I invoke and use this module in ThisWorkbook with the following code:


Option Explicit

Private Sub Workbook_Open()
Create_Menu
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Delete_Menu
End Sub


Earlier in xl2003, when i open a workbook containing this menu module (code attached), i can see a hanging commandbar with a button showing the text Extract Samples. Now, since i've migrated to 2007, i'm not able to see this commandbar.

Is there any alternative to this commandbar in xl2007?? I explored a bit in the help section. It says that xl2007 uses ribbon interface. Can this module be recoded using this ribbon object and can i create a small ribbon-bar with my own buttons as required?


Ranga

xld
08-04-2010, 09:45 AM
No.

But if you open the Addins tab, you will see your commandbar there.