Using Form elements in Excel 2007

Posted on 2009-12-27
Last Modified: 2012-05-08
I have long been accustomed to using Excel 2003, and I've been laboring to get used to 2007 at work.  I really don't like the ribbon, and I'm sorry they did such a major redesign of the reliable and capable drop-down menu.  
I am trying to figure out how to place form elements in an Excel worksheet, and none of the menus seem to provide this most basic function.  As an experiment, I created a simple button in 2003 and opened the file in 2007; and my button both opened and performed the desired function when I pushed it.  From that experiment, I surmise that the capability of creating buttons, text boxes, check boxes, radio buttons, etc. in 2007 must exist, I just can't find it.
Best, ~Peter Ferber
Question by:PeterFrb
    LVL 5

    Accepted Solution

    You need to turn on the developer ribbon, (I know it's lame)... click on the file ribbon (or hit the flag), and select Excel Options
    then on the right hand side select popular, then the third checkbox down you will see "show the developer toolbar in ribbon" or something like that.

    Author Closing Comment

    Lame is the word!  (Excel, not you.)
    Best, ~Peter

    Author Comment

    Yes, that's right, lame though it be.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now