| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a control button to insert rows
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create button to unhide rows directly below | Excel Discussion (Misc queries) | |||
| How do I create a Macro to sort data and insert blank rows & subto | Excel Worksheet Functions | |||
| how do I create a macro to auto insert rows? | Excel Worksheet Functions | |||
| Adding a control button to insert a date in the active cell. | Excel Discussion (Misc queries) | |||
| How do I create a button or control that will automatically go to | Excel Worksheet Functions | |||
Threaded Mode
