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

Thread: Macro Buttons

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello
    I have some buttons for my macros in the workbook. However, when I distribute them to other people by e-mail. Those buttons are not there any more
    Could someone please help me out

    Thanks in advance

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you attached the toolbar to the worksheet?

    Right click on a toolbar, goto customize, highlight your toolbar, and click attach.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If I have two buttons created in the standard toolbar. How can I attach those two buttons to the toolbar?


    Thanks in advance

  4. #4
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you are sending this workbook out to other users, then I recommend that you create a custom toolbar to hold your macro buttons.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  5. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Allen

    RE: If I have two buttons created in the standard toolbar. How can I attach those two buttons to the toolbar?

    Unless you use code you basically cannot. A Custom toolbar as Al suggests is normally the better option.




  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yes, custom toolbar is perfect
    Thanks guys

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
  •