+ Reply to Thread
Results 1 to 2 of 2

Quick question - quick answer about assigning shortcut keys

  1. #1
    Forum Contributor funkymonkUK's Avatar
    Join Date
    01-07-2005
    Location
    London, England
    Posts
    500

    Quick question - quick answer about assigning shortcut keys

    Hi

    Is there a way to assign shortcut keys with some code? I know when you record a macro it askes you if you would like to assign a shortcut. any idea and is so is there a way to update the shortcut keys?

    many thanks

  2. #2
    Stefi
    Guest

    RE: Quick question - quick answer about assigning shortcut keys

    I tried to record as a macro assigning a hot key to an other macro and I got
    this:
    Application.MacroOptions Macro:="Macroname", Description:= _
    "Recorded by MyName, date: 10/13/2005.", ShortcutKey:="r"

    Stefi

    "funkymonkUK" wrote:

    >
    > Hi
    >
    > Is there a way to assign shortcut keys with some code? I know when you
    > record a macro it askes you if you would like to assign a shortcut. any
    > idea and is so is there a way to update the shortcut keys?
    >
    > many thanks
    >
    >
    > --
    > funkymonkUK
    > ------------------------------------------------------------------------
    > funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
    > View this thread: http://www.excelforum.com/showthread...hreadid=475729
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1