Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In relation to macros
I have recorded a macro and i wish to keep the keyboard shortcut as ctrl C. I
have recorded keeping the short key as ctrl Q. Kindly help how can i change it? Second thing once i click record macro excel is not asking for relative reference option. Kindly help how can i get that as well. Thanks Boss |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In relation to macros
To assign/re-assign shortcuts:
ALT-F8 Options (I like CNTRL-e and CNTRL-f because I use CNTRL-c for copy) To get that relative button: View Toolbars Visual Basic BEFORE you start recording -- Gary''s Student - gsnu200754 "Boss" wrote: I have recorded a macro and i wish to keep the keyboard shortcut as ctrl C. I have recorded keeping the short key as ctrl Q. Kindly help how can i change it? Second thing once i click record macro excel is not asking for relative reference option. Kindly help how can i get that as well. Thanks Boss |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
In relation to macros
On this topic, I have no icon my my Visual Basic toolbar that seems to
control relative addressing. Am I missing something? Thanks, James "Gary''s Student" wrote in message ... To assign/re-assign shortcuts: ALT-F8 Options (I like CNTRL-e and CNTRL-f because I use CNTRL-c for copy) To get that relative button: View Toolbars Visual Basic BEFORE you start recording -- Gary''s Student - gsnu200754 "Boss" wrote: I have recorded a macro and i wish to keep the keyboard shortcut as ctrl C. I have recorded keeping the short key as ctrl Q. Kindly help how can i change it? Second thing once i click record macro excel is not asking for relative reference option. Kindly help how can i get that as well. Thanks Boss |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
In relation to macros
Hi James
you may need the Stop Recording Toolbar as well. -- Gary''s Student - gsnu200754 "Zone" wrote: On this topic, I have no icon my my Visual Basic toolbar that seems to control relative addressing. Am I missing something? Thanks, James "Gary''s Student" wrote in message ... To assign/re-assign shortcuts: ALT-F8 Options (I like CNTRL-e and CNTRL-f because I use CNTRL-c for copy) To get that relative button: View Toolbars Visual Basic BEFORE you start recording -- Gary''s Student - gsnu200754 "Boss" wrote: I have recorded a macro and i wish to keep the keyboard shortcut as ctrl C. I have recorded keeping the short key as ctrl Q. Kindly help how can i change it? Second thing once i click record macro excel is not asking for relative reference option. Kindly help how can i get that as well. Thanks Boss |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
In relation to macros
Okay, thanks! I will check on that. Relative addressing sounds like a
really bad idea to me. Guess it works for some people. I tend to like things to be absolute (which is probably why I like Excel to begin with!). But I don't want to miss out on anything! Regards, James "Gary''s Student" wrote in message ... Hi James you may need the Stop Recording Toolbar as well. -- Gary''s Student - gsnu200754 "Zone" wrote: On this topic, I have no icon my my Visual Basic toolbar that seems to control relative addressing. Am I missing something? Thanks, James "Gary''s Student" wrote in message ... To assign/re-assign shortcuts: ALT-F8 Options (I like CNTRL-e and CNTRL-f because I use CNTRL-c for copy) To get that relative button: View Toolbars Visual Basic BEFORE you start recording -- Gary''s Student - gsnu200754 "Boss" wrote: I have recorded a macro and i wish to keep the keyboard shortcut as ctrl C. I have recorded keeping the short key as ctrl Q. Kindly help how can i change it? Second thing once i click record macro excel is not asking for relative reference option. Kindly help how can i get that as well. Thanks Boss |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
In relation to macros
It's not so much personal preference that should determine whether you use
absolute or relative addressing; it should be the application requirements. It is quite typical to have both code and worksheet functions that make a use of a combination of both addressing methods. Consider: =VLOOKUP(A1,'Sheet2'!$A$5:$AA$10000,13,False) The table needs to be absolutely addressed so that when the formula is filled down the sheet, that lookup table reference doesn't change, but similarly, the item to be looked up, in A1 initially, needs to be relatively addressed so that the row reference will increase as the formula is filled down the sheet. Function quite often dictates design. "Zone" wrote: Okay, thanks! I will check on that. Relative addressing sounds like a really bad idea to me. Guess it works for some people. I tend to like things to be absolute (which is probably why I like Excel to begin with!). But I don't want to miss out on anything! Regards, James "Gary''s Student" wrote in message ... Hi James you may need the Stop Recording Toolbar as well. -- Gary''s Student - gsnu200754 "Zone" wrote: On this topic, I have no icon my my Visual Basic toolbar that seems to control relative addressing. Am I missing something? Thanks, James "Gary''s Student" wrote in message ... To assign/re-assign shortcuts: ALT-F8 Options (I like CNTRL-e and CNTRL-f because I use CNTRL-c for copy) To get that relative button: View Toolbars Visual Basic BEFORE you start recording -- Gary''s Student - gsnu200754 "Boss" wrote: I have recorded a macro and i wish to keep the keyboard shortcut as ctrl C. I have recorded keeping the short key as ctrl Q. Kindly help how can i change it? Second thing once i click record macro excel is not asking for relative reference option. Kindly help how can i get that as well. Thanks Boss |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
relation between 'items' en 'prices' | Excel Worksheet Functions | |||
#REF problems in a relation between worksheets | Excel Discussion (Misc queries) | |||
relation equation between two columns | Excel Worksheet Functions | |||
how can i find the relation between x & y in chart | Charts and Charting in Excel | |||
Cell relation ships. | Excel Discussion (Misc queries) |