you can use Ctrl + <character> or ctrl + shift + <character> combinations.
while entering the key into the dialog box, you have to use only the
character or shift + character. while running the macro, you have to use
ctrl along with them.
Umesha
----- Original Message -----
From: "Amiyo Biswas" <amiyo.bis...@gmail.com>
To: <accessindia@accessindia.org.in>
Sent: Tuesday, 18 December, 2012 12:29 PM
Subject: Re: [AI] Create a shortcut key for macro
Go to the macros pressing alt+f8.
Tab over to the next control which is a list box for all your macros in
that excel file. Select the desired macro using arrow keys.
Tab over to the options ... button and hit enter key.
Here you will find the field for shortcut key. Press any lettter such as
t. Excel will assign ctrl+t as hot key to this macro.
I tried other combinations, but without success. This is all for office
2003.
With best Regards,
Amiyo Biswas
Cell: +91-9433464329
----- Original Message -----
From: "Mukesh" <mukeshbaviskar....@gmail.com>
To: "Access India" <accessindia@accessindia.org.in>
Sent: Tuesday, December 18, 2012 11:22 AM
Subject: [AI] Create a shortcut key for macro
Hello Friends,
I have learned to record a macro in excel but still I'm confused to
create a shortcut key for a recorded macro. Please guide me how to create
a macro shortcut key. There is a option shortcut key but I don't know
which keys are used, what are the combinations of keys available for
macro. Thanking you in anticipation.
Regards
Mukesh Baviskar
Mobile: 9403161157
Register at the dedicated AccessIndia list for discussing accessibility
of mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in