Setting up "Cntrl I" as shortcut to Insert

[LooLoo]

I had to reinstall Excel 2000 after a hard drive crash. Previously, I was
able to insert, say, a row by selecting a row and using Cntrl I as a shortcut
key. I cannot find how to set this up. Please help.

 

[David McRitchie]

First thing you have to know is the name of the macro you want to call.
If you don't know. Go to the first module in you personal.xls and/or
your current workbook. (not at same time). then do a find "insert"
be sure to use the project library radio button. Once identified.

Ctrl + F8 (tools, macro), select the macro form list, Options,
assign the shortcut key.

You might want to review: the following if you have additional
questions on this. The shortcut would be store in your .xlb
(toolbars) file..
Getting started with macros.
http://www.mvps.org/dmcritchie/excel/excel.htm
Backup:
http://www.mvps.org/dmcritchie/excel/backup.htm
Toolbars
http://www.mvps.org/dmcritchie/excel/toolbars.htm