Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activex controls out of control
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
activex controls out of control
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
activex controls out of control
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
activex controls out of control
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
activex controls out of control
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
publish activeX combobox and other activeX control | Excel Programming | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
activex controls, no "Control tab" | Excel Discussion (Misc queries) | |||
linking ActiveX Controls to perform function on another control | Excel Programming | |||
Accessing ActiveX Controls using VBA - can't use Control.Name to access. | Excel Programming |