Add row button?

Question

OK, might sound dumb but, is there a way to create a little "Add row" button on a spreadsheet so that those with NO excel knowledge can add a new row before the row I have used to sum a column? Also, can I make the little button not print or show when the document is printed? I would prefer not to use macros if possible because this document will have to be opened by multiple users who may or may not have macros enabled and/or know how to enable them.

Answer 1

How about recording a macro. I got this:

Sub a_row_insert()

'

' a_row_insert Macro

'

'

    Selection.EntireRow.Insert

End Sub

Then you can put the code into a button using this tip:

Adding Buttons to Your Worksheet

**http://excel.tips.net/Pages/T002479\_Adding\_Buttons\_to\_Your\_Worksheet.html******