Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet where I need to quickly display hidden rows (so as to
€˜drill-down to more detailed information) and then re-hide the rows when necessary. I have set up command buttons linked to the following macros to do this: _____ Private Sub CommandButton11_Click() Rows("88:88").Select Selection.EntireRow.Hidden = False Range("A88").Select End Sub Private Sub CommandButton12_Click() Rows("88").Select Selection.EntireRow.Hidden = True End Sub _____ This works perfectly well until I insert or delete rows above the command buttons. When I do that, the buttons now hide the wrong rows. Is it possible to lock the macro so that it will only affect the desired rows, wherever they are in the worksheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command buttons | Excel Discussion (Misc queries) | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Help with command buttons | Excel Worksheet Functions | |||
command buttons | Excel Worksheet Functions |