Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Short cuts (Excel 2000)

    Are there any reuable tools or components that can be used to help remap short cut keys to perform a different function. I am asking this because Word and Excel have used up the key combinations for shortcuts and we are going to give our customers the option to remap shortsut keys for their session and am wondering if there are not already some reuable code or components that we could use rather than invent it.

    Thank you

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Short cuts (Excel 2000)

    In VB you can use the line:

    Application.MacroOptions Macro:="Macro1", ShortcutKey:="c"

    To change "rempa" the shortcut key to Macro1 to ctrl-c and so it will no longer copy
    Running:
    Application.MacroOptions Macro:="Macro1", ShortcutKey:=""
    Will reset it back to the "normal operation" of copy

    Steve

Posting Permissions

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