Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default Macro Letters

Hi, When you record a Macro, you assign a letter to it. There is a limited
number of letters I can use since some of the letters are already used in
conjuction with Control key. (i.e Letter C for copy). How do you invoke a
Macro with Contol+Shift+and a letter. I just forgot how i did in the past.
Can you also use the Control+Shift and Letter in 2007?

Thanks,
Dinesh
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,393
Default Macro Letters

Yes, hold both SHIFT and CTRL while you 'tap' the C key
You make this association when recording the macro
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dinesh" wrote in message
...
Hi, When you record a Macro, you assign a letter to it. There is a limited
number of letters I can use since some of the letters are already used in
conjuction with Control key. (i.e Letter C for copy). How do you invoke a
Macro with Contol+Shift+and a letter. I just forgot how i did in the past.
Can you also use the Control+Shift and Letter in 2007?

Thanks,
Dinesh



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 204
Default Macro Letters

You just type a capital C into the box, then the shortcut becomes
Ctrl+Shift+C

M


"Dinesh" wrote in message
...
Hi, When you record a Macro, you assign a letter to it. There is a limited
number of letters I can use since some of the letters are already used in
conjuction with Control key. (i.e Letter C for copy). How do you invoke a
Macro with Contol+Shift+and a letter. I just forgot how i did in the past.
Can you also use the Control+Shift and Letter in 2007?

Thanks,
Dinesh


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Formating Letters to Numbers while Displaying Letters Luke Androsiglio Excel Worksheet Functions 2 March 31st 10 06:29 PM
Macro to group sheet by certain letters at the end bioyyy Excel Discussion (Misc queries) 8 October 26th 08 05:17 AM
How do change a column of data in capitol letters to small letters Barb P. Excel Discussion (Misc queries) 6 November 15th 06 06:17 PM
Replace first 8 letters of filename with Macro [email protected] Excel Programming 5 February 21st 06 03:51 PM
Sort function or macro for the first 4 letters Matz Excel Worksheet Functions 5 August 29th 05 01:49 PM


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"