There is an insert row button on the ToolsCustomizeCommandsInsert category
that can be dragged to a new toolbar you crate by ToolsCustomizeToolbarsNew

You can dock that most anywhere.

If you really want a macro assigned to a button, drop a button from the Forms
Toolbar onto your sheet and assign this code.

Sub insert()
Selection.EntireRow.insert
End Sub


Gord Dibben MS Excel MVP


On Mon, 14 May 2007 17:55:01 -0700, nadswilkes28
wrote:

I want to creat a button on my spreadsheet then when you click on it you will
automatically insert a row above it.