Unhide/Hide column when choosing dropdown list

[yuzi]

Hi,

I'm not sure if this is possible or not but maybe someone can help.
Is there a way to have a column unhide one choosing a certain value from a dropdown list (validation)?
I want the column to be hidden throughout the worksheet until a specific value is chosen in the list. Once it's chosen then I want it to unhide that column.

Any help would be appreciated.
Thanks.

[DonkeyOte]

Can you post an example file that demonstrates your requirements ?

You will need to use VBA to toggle column visibility.

[yuzi]

I've attached an example.
I want column S (Transfers In Cost Centre) to be hidden until they choose Transfers within BMO in column R.

[Palmetto]

In the worksheet module:

Option Explicit

Private Sub Worksheet_Activate()

'hide column-S upon activating the sheet

    Columns("S").EntireColumn.Hidden = True
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim lrow As Long
    
    lrow = Cells(Rows.Count, 1).End(xlUp).Row
    
'toggle column-S visibility
    
    If Not Intersect(Target, Range("R2:R" & lrow)) Is Nothing Then
        Columns("S:S").EntireColumn.Hidden = Target.Value <> "Transfer"
    End If

End Sub

[yuzi]

Thank you this worked.