activex controls out of control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
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

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