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

08-04-2010, 09:30 AM

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()
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
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?


08-04-2010, 09:45 AM

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