Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Formating Letters to Numbers while Displaying Letters | Excel Worksheet Functions | |||
Macro to group sheet by certain letters at the end | Excel Discussion (Misc queries) | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
Replace first 8 letters of filename with Macro | Excel Programming | |||
Sort function or macro for the first 4 letters | Excel Worksheet Functions |