If there is nothing on the button properties, you can grab the top and left
of the buttons before the code executes, and then reset the buttons to those
locations.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"timp" wrote:

Thanks Jim, but...there are 3 settings; none of them holds the button still
for programmatic row deletion - though setting 3 will hold it in the same
place for manual row deletion.

Tim


"Jim Thomlinson" wrote:

Right click the control and select Format Control - Properties and change
the settings to whatever makes your heart go pitter patter...
--
HTH...

Jim Thomlinson


"timp" wrote:

I have activex buttons on my spreadsheet. Their placement property is set to
3 so that they should stay still. But whenever I delete rows (with code, but
not manually) they slide down the page (until they eventually disappear off
the screen). Does anyone know how to control this?

thanks