View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
steal_92 steal_92 is offline
external usenet poster
 
Posts: 1
Default 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?