Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Seymour, Connecticut, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Assigning XL macro

    In Excel 97 i wanted to record a macro which would create a
    toolbar button (by dragging it from the button choices), assigning a macro to it and then modifying the appearance of the button. The last two can be in any order. The macro only seems to record as far as placing the button on the toolbar without assigning the macro or modifying the
    buttons appearance. What am I doing wrong?

    Thanls in advance Tom L.

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Assigning XL macro

    Have a look at

    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=30032&page=2&view =expanded&sb=5>This thread</A>

    this might help you. I think Excel is not recording all the steps you are taking when recording the creation of a toolbar, adding a button and assigning a macro to it.

Posting Permissions

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