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

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

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

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

JOhn

thanks for the suggestion - it's past my bed-time now so I will give it a
shot in the morning.

"John Bundy" wrote:

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