from a post of mine just today. Was it you?

right click sheet tabview codecopy/paste thissave
now when you double click any cell in the column it will show that column
ONLY until you double click any cell in the visible column again.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If columns("iv").Hidden = True Then
columns("a:iv").EntireColumn.Hidden = False
Exit Sub
Else
columns("a:iv").EntireColumn.Hidden = True
columns(ActiveCell.Column).EntireColumn.Hidden = False
End If
End Sub


--
Don Guillett
SalesAid Software

"minka" wrote in message
...
Hi,

I'm a novice at using excel and I'm trying to create a macro that will;

When the worksheet is opened, an option can be selected (ticked).....that
will unhide all rows that have a certain value in column 'A'.

Then when this option is selected on again (unticked), it will hide rows
that have a certain value in column 'A'.