Macro button to display after rows are deleted

[howard]

I have a macro that is deleted once rows are deleted using a macro.


I would like if there is a way for the button to appear on the sheet once the rows are deleted

 

[nemmi69]

commands to make a button visible/invisible

Sub Buttonvisible()
'
ActiveSheet.CommandButton1.Visible = True


End Sub


Sub Buttoninvisible()
'
ActiveSheet.CommandButton1.Visible = False


End Sub

 

[nikio8]

Format your button or properties, "do not move or size with cells", something like that

 

[howard]

Thanks for your input