Welcome Guest
Log In | Register )
You last visited December 7, 2016, 10:55 pm
All times shown are
Eastern Time (GMT-5:00)

excel ? --automatic button creation

Topic closed. 3 replies. Last post 11 years ago by lottaloot.

Page 1 of 1
PrintE-mailLink
lottaloot's avatar - AvatarZ56
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
Posted: April 21, 2006, 9:50 am - IP Logged

Does anyone know how to create a button within excel???????? 

I would like to insert a button function that would automatically run a macro for my spreadsheet. 

I have so many macros within this spreadsheet that it is becoming a little confusing to keep them straight--so I thought that if I added a button for the most commonly used ones, it would be better for me. 

L ttaL   T

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: April 21, 2006, 10:00 am - IP Logged

    View>> Toolbars>>Forms

    Click the "Button" icon

    A window will open asking you what macro you want to associate with this button

    You can Edit the button by adding text to the button.

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: April 21, 2006, 10:01 am - IP Logged


      I should have added that you can adjust the size of the button.

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: April 21, 2006, 11:10 am - IP Logged

        Thanks so much,WSLS

         

        L ttaL   T