ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro keys to avoid (https://www.excelbanter.com/excel-programming/437900-macro-keys-avoid.html)

Robert Crandal

Macro keys to avoid
 
Which macro control keys in Excel are usually reserved
or which keys should I avoid???

For example, I would not pick Ctrl-C, Ctrl-V or Ctrl-Z
because those are usually reserved for Copy, Paste and
Undo respectively. It seems like so many other letters
would be taken or reserved for common Excel
actions!



Javed

Macro keys to avoid
 
On Dec 31, 1:55*pm, "Robert Crandal" wrote:
Which macro control keys in Excel are usually reserved
or which keys should I avoid???

For example, I would not pick Ctrl-C, Ctrl-V or Ctrl-Z
because those are usually reserved for Copy, Paste and
Undo respectively. * *It seems like so many other letters
would be taken or reserved for common Excel
actions!


Following is the list commonly used

Ctrl+A
Ctrl+B
Ctrl+C
Ctrl+D
Ctrl+F
Ctrl+G
Ctrl+I
Ctrl+K
Ctrl+N
Ctrl+O
Ctrl+P
Ctrl+Q
Ctrl+R
Ctrl+S
Ctrl+U
Ctrl+V
Ctrl+W
Ctrl+X
Ctrl+Z

It is safe to use Ctrl+Shift+A or Ctrl+Shift+B etc...

For details press F1 and type Keyboard Shortcut in text box.




Mike H

Macro keys to avoid
 
Hi,

The full list of assigned shortcuts

http://office.microsoft.com/en-us/ex...116591033.aspx

Mike

"Robert Crandal" wrote:

Which macro control keys in Excel are usually reserved
or which keys should I avoid???

For example, I would not pick Ctrl-C, Ctrl-V or Ctrl-Z
because those are usually reserved for Copy, Paste and
Undo respectively. It seems like so many other letters
would be taken or reserved for common Excel
actions!


.


Robert Crandal

Macro keys to avoid
 
That might not be the "full" list. It doesn't list "Ctrl-T" as an assigned
shortcut,
yet that key combination seems to be already reserved for a "create table"
option.



"Mike H" wrote in message
...
Hi,

The full list of assigned shortcuts

http://office.microsoft.com/en-us/ex...116591033.aspx

Mike




All times are GMT +1. The time now is 07:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com