Delete entire row in excel shouldn't delete the button present in the same row

1
votes

I have my data from column A to column F in an excel sheet.

I have created a button in other columns somewhere in the mid of the page like H5

No when i delete the invalid data manually by just selecting the row number and delete that should delete the entire row.

But my requirement is we should be deleting the entire row for ex: if row 5 has invalid data.

We will delete the invalid row by selecting row 5 and delete.But we do have a button in the same row of H column. The requirement is that the button shouldn't be deleted.

Is there any way where i can retain the button even the entire row is deleted.I tried locked cells,panes and splits.

But no luck. Could you please help me in this ?

1
excelexcel-formulaexcel-2007excel-2010vba
subject and post seem to contradict each other, What type of button is it,is it linked to a cell and you want the button kept or deleted? – Steven Martin
sorry @Steven Martin.i have corrected it now..do you know if there is a way other than macro recording to delete the rows only until column F and freeze the rest of the columns in that row? – user2075017

1 Answers

4
votes

Right-click the button, choose "Format Control" and under Properties choose "Don't Move or Size with Cells." This works for both Forms and ActiveX type buttons.