| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a control button to insert rows
Add an Active-X Command Button to your worksheet.
Then in the Sheet Code window select the object Command_Click (left drop-down)and make it look like this: Private Sub CommandButton1_Click() ActiveCell.EntireRow.Insert '<<< Add this End Sub Hope this helps, Jim May "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
