unhiding columns if another cell has value

[the blue fox] · Dec 17th 2005

Hi all .. hope for some help on this

I have some column hidden within a spreadsheet [a.xls] that is linked to another file [b.xls].

I was hoping that I could find the code that if someone was to type into A1 of b.xls .. that certain columns would open up in a.xls.

Is this possible?

HELP :?

carlmack · Dec 17th 2005

Re: unhiding columns if another cell has value

You could use the worksheet change event.

Code

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("a1").Value = "b.xls" Then
    Range("e:f").Columns.Hidden = False
End If
End Sub

Here I am assuming that the hidden columns are column E and F.

The code would need to go in the sheet module. If you right click on the worksheet tab and select view code you will get there.
HTH

Participate now!