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
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