Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command buttons linked to moving rows
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command buttons linked to moving rows
Name a cell in the row and use that name in your code. Also, you do not need two buttons or two sets of code... Range("TheCell").EntireRow.Hidden = Not Range("TheCell").EntireRow.Hidden -- Jim Cone Portland, Oregon USA "steal_92" wrote in message 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command buttons linked to moving rows
Thanks for you response Jim, that really helps
"Jim Cone" wrote: Name a cell in the row and use that name in your code. Also, you do not need two buttons or two sets of code... Range("TheCell").EntireRow.Hidden = Not Range("TheCell").EntireRow.Hidden -- Jim Cone Portland, Oregon USA "steal_92" wrote in message 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |