Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Attaching a macro to a button that sits on the worksheet whe

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    England
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I need to attach a macro that i have built onto a specific page in the spreadsheet. I believe this can be done using a button and attaching the macro to the button but can't work out how to do it. I do not want the macro to sit on the toolbar.

    Can anyone help?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Brisbane, Down Under
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try View, Toolbars, Forms then depress the button icon and on your spreadsheet drag a button to the size you want. Excel will lead you through the process of assigning the macro. Any time you want to edit the button right click on it first otherwise you will invoke the macro.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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