ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   keeping buttons from moving (https://www.excelbanter.com/excel-programming/303880-keeping-buttons-moving.html)

Lester Lee

keeping buttons from moving
 
I have a sheet that hides and unhides rows depending on the user's
answers, these rows also have toolbox command boxes that erase the
user's answers. My problems is that certain times when there is a row
that is unhidden, the command box is not lined up with the row, in fact
its serveral rows up or down. Is there anyway to fix the button to a
particular row so that it does not move around.

Thanks,

Lester

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Kura of Tyren

keeping buttons from moving
 
You may find it helpful to simply use some positioning
commands such as
cmdbutton1.top= valuea
and
cmdbutton1.left= valueb
To simply set the command button to the location you'll
want it to appear at whenever the row is made visible
again. Simply enter code similar to that wherever code is
executing that is causing the button to be moved.


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com