They mean Visual Basic code to program the spreadsheet to do a certain
behavior. In Excel 2003 and earlier, this functionality is found
under Tools-Macros. In Excel 2007, you will find it under the
Developer tab, which is hidden by default and must be enabled under
Excel Options.

When you use the "record macro" functionality, it will automatically
generate Visual Basic code, also providing you an option to assign a
shortcut key for this code. During recording, Excel will keep track
of everything you do, which will later enable you to repeat these
actions simply by running the macro or using the shortcut key
combination that you specified.

Many advanced users prefer to do this manually. For example, follow
this sequence of steps:

1. In your workbook (save a copy), press Alt+F11. You will see the
Visual Basic editor.
2. In VBE, under the Insert menu, choose Module.
3. Paste the following code:

Public Sub InsertRow()
ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Insert Shift:=xlDown
End Sub

4. Close the VBE to return back to Excel.
5. In Excel, press Alt+F8 to show the Macros menu.
6. Select one called InsertRow, and press Run. A row will be
automatically inserted after your current cursor position.
7. Press Alt+F8 again, select InsertRow, and click on Options.
8. Go into the small shortcut key textbox next to Ctrl+ and press Shift
+R.
9. Press OK, then Cancel to close the Macros menu
10. In Excel, press Ctrl+Shift+R. A row will be automatically
inserted after your current cursor position.


Hope this helps.


On Oct 30, 3:39 pm, susy wrote:
HI,.........went to hlp to find outwhat is macro and what can I do with it
but the help explanatin are vague. I'm not familair to all th epossibilities
in Excell.

For example help told me to record a code,.......what do they mean with
code, formulas? and if so what fomula should I apply in thiss case?



"Pete_UK" wrote:
You would have to do it with a macro - record a macro (in relative
addressing mode) while you do it once, then you can apply a short-cut
key or button to run the macro whenever you like.

Hope this helps.

Pete

On Oct 5, 6:54 pm, susy wrote:
Hi my name is susy,

I'm working on a finacial structure that should be used for entry of data by
many person. I thought about locking the worksheet, but some else shoul be
able to insert a row a keep working withou messing with my formulas.

What should I do to automatically insert a row with the same formula at
least with the same formats?

susy- Hide quoted text -

- Show quoted text -