Setting up "Cntrl I" as shortcut to Insert

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top