Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keeping Control Buttons Still | Excel Worksheet Functions | |||
Keeping data in a cell stationary while the spreadsheet is scroll | Excel Discussion (Misc queries) | |||
hiding/unhiding rows & columns with "+" and "-" buttons | Excel Discussion (Misc queries) | |||
keeping buttons from moving | Excel Programming | |||
Excel VBA - Keeping a chart stationary in a worksheet while scrolling | Excel Programming |