Don't think you can do it with a Return/Enter, but maybe
one of the VB experts can help.
You can simplify the process a bit by doing two things.
First, set your cursor response option
(Tools/Options/Edit) to move Down when you do hit Enter.
Second, add the Insert Row button to one of your visible
tool bars. Then, when you hit Enter, the cursor moves to
the next row, and all you have to do it click the Insert
Row tool icon.
HTH
-----Original Message-----
is there a way so that if i press return a new row is
inserted, or do you have to do the insert row function
everytime?