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