Menu
Ask a question Report

Conditional hide column [Solved/Closed]

- - Latest reply:  issa - Jul 21, 2011 at 11:59 PM
Office Software Ask a question Report
Hello,

I need someone to help me please.

I want a VBA code in excel that will look to a value in specific cell (i.e: A1) in one sheet only and if this cell is equal to "1" for instance to hide column No 5 (which is "E") but this to be automatic, I mean if the value changed in A1 it should automatically hide/Undide that column (E) according the value in A1.

Thank you in advance.
See more 

2 replies

Best answer
Report Respond to venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 923
3
Thank you
i am rephrasing it

1. if type 1 in A1 column E should be hidden
2. If I type any other number column E should be visible

in that case
right click sheet tab and click view code
in the window that comes up copy this EVENT CODE 

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$1" Then Exit Sub
If Target = 1 Then
Range("e1").EntireColumn.Hidden = True
Else
Range("e1").EntireColumn.Hidden = False
End If
End Sub


now type some number in A1. if it is 1 colum E will be hidden
if it some other number the column E will not be hidden

if you enter in any cell other than A1 nothing will happen

do some experiments.

Say "Thank you" 3

A few words of thanks would be greatly appreciated. Add comment

CCM 4586 users have said thank you to us this month

Report Respond to issa
0
Thank you
Thank you indeed.
It worked as needed.
Thanks again.

Issa
Ask a question