+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Ribbon Object in xl2007 vs CommandBar Object in xl2003

  1. #1
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Lightbulb Ribbon Object in xl2007 vs CommandBar Object in xl2003

    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:

    Please Login or Register  to view this content.

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

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Ribbon Object in xl2007 vs CommandBar Object in xl2003

    Your menu will be in the addins Tab.

    It's more complicated with 2007 but you can actually edit the Ribbon, see Ron de Bruin's site for starters
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1