LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Keeping buttons stationary when unhiding rows.


Alright y'all. I have a [very cumbersome] solution to a particular
problem, but I'd like to know if there is a better one.

The setup: Basically, I have buttons that hide and show different
options further down the sheet which leads to other buttons and such.

The problem: When unhiding rows (and the buttons that corresponds) the
*button*.top = number changes depending on how many rows are shown.

On another sheet I just brute forced it and worked out every option and
put an if-then for every option. If at all possible, I'd like to avoid
doing that again.

Does anyone have any ideas in which direction I could take this?


--
wilro85
------------------------------------------------------------------------
wilro85's Profile: http://www.excelforum.com/member.php...o&userid=26935
View this thread: http://www.excelforum.com/showthread...hreadid=557948

 
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
Keeping Control Buttons Still ZipCurs Excel Worksheet Functions 1 December 14th 05 10:41 PM
Keeping data in a cell stationary while the spreadsheet is scroll Tammy Excel Discussion (Misc queries) 1 September 23rd 05 02:59 PM
hiding/unhiding rows & columns with "+" and "-" buttons shellshock Excel Discussion (Misc queries) 2 August 3rd 05 05:22 AM
keeping buttons from moving Lester Lee Excel Programming 1 July 13th 04 06:00 PM
Excel VBA - Keeping a chart stationary in a worksheet while scrolling mangesh_yadav Excel Programming 6 June 17th 04 10:34 AM


All times are GMT +1. The time now is 10:00 PM.

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

About Us

"It's about Microsoft Excel"