Results 1 to 3 of 3
  1. #1
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Macro Launch Keys (Excel 2000)

    I was sent a template to translate a csv file to a .xls file. Unfortunately the author used common keys to launch macros, e.g. Ctl+V, Ctl+X. This plays havoc with my processing if this file is opened at the same time as others.
    How do I re-define the macro launch keys? I would prefer to delete the quick keys as I would then add buttons to the workbook to launch the macros.
    Paul Coyle
    Approach love and cooking with reckless abandon

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro Launch Keys (Excel 2000)

    Select Macro from the Tools menu then select Macros from the fly out menu. Select the macro in the list and click on the Options button. There should be a place there to change the shortcut key.
    Legare Coleman

  3. #3
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Macro Launch Keys (Excel 2000)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15> Looking at the problem from the wrong angle. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>
    Thanks Legare

    <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>
    Paul Coyle
    Approach love and cooking with reckless abandon

Posting Permissions

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