Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving data without keeping formula Zack Excel Discussion (Misc queries) 1 August 21st 08 10:58 PM
Keeping moving wilchong via OfficeKB.com New Users to Excel 2 July 2nd 08 11:18 AM
Help keeping my cursor from moving to the end of the document. Angelica Excel Discussion (Misc queries) 3 July 10th 06 10:29 PM
Keeping Control Buttons Still ZipCurs Excel Worksheet Functions 1 December 14th 05 10:41 PM
keeping track of stock moving from one location to another DL[_3_] Excel Programming 4 September 1st 03 10:09 PM


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"