Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data without keeping formula | Excel Discussion (Misc queries) | |||
Keeping moving | New Users to Excel | |||
Help keeping my cursor from moving to the end of the document. | Excel Discussion (Misc queries) | |||
Keeping Control Buttons Still | Excel Worksheet Functions | |||
keeping track of stock moving from one location to another | Excel Programming |