Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    On my new PC, I've reinstalled 2003, but when I try to run a macro on a tab, I get the button in some kind of edit mode and it doesn't resort the rows as usual. Can't seem to find a way to get the macro to run when I click the button.TYIA

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='Torquemada' post='775423' date='15-May-2009 19:59']On my new PC, I've reinstalled 2003, but when I try to run a macro on a tab, I get the button in some kind of edit mode and it doesn't resort the rows as usual. Can't seem to find a way to get the macro to run when I click the button.TYIA[/quote]
    I suspect that the button points to a macro that was located in a project which no longer exists or has been moved. To determine what we are looking for:
    1. Pull down Tools > Customize
    2. Select the Command tab
    3. Click Macros in the Categories list
    4. Click the Rearrange Commands button
    5. Click the Toolbar button
    6. Select the toolbar containing the macro from the Toolbar list
    7. Click the Modify Selection button
    8. The pathname of the macro will be displayed in the Macro Name box.
    9. Having determined where and what we are looking for; cancel and close out of the customize menu.
    H.T.H.
    Regards
    Don

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Worked fine, thanks.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='wdwells' post='775427' date='16-May-2009 00:34'][*]Click the Rearrange Commands button[/quote]
    I never knew about that button!

    I just rightclick the toolbar, select customize, then rightclick a button and select assign macro.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='pieterse' post='775553' date='17-May-2009 06:12']I just rightclick the toolbar, select customize, then rightclick a button and select assign macro.[/quote]

    And I think your method is by far the more efficient.
    Regards
    Don

Posting Permissions

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