Luke

Why not just one button to toggle hide or not hide?

Sub togglerows()
Dim rng As Range
Dim Cell As Range
Set rng = ActiveSheet.Range("A10:A14")
rng.EntireRow.Hidden = Not rng.EntireRow.Hidden
End Sub


Gord Dibben MS Excel MVP


On Fri, 7 Dec 2007 11:25:04 -0800, Luke M
wrote:

If the information is a whole row/column, you could record of macro of you
hiding the rows, and unhiding the rows (seperate recordings, of course)

Then just assign the macros to two buttons