hide/unhide columns based on dropdown list.

The macro you need is sheet specific and runs whenever you change the sheet,

The macro checks to see if the cell that was changed was in column D.

If so the macro then reads the cell and modifies your spreadsheet.

If you had included a sample I'd know how to help you further.

How did you create a drop down list in the whole of column D.

why not on the top row and freeze the window?

Hi Nephi,

I'm not sure I understand what you mean about the result of hiding columns for rows where the D cell in a row contains either No or Call Back. You could hide the rows where D contains those values but not just some of the cells on those rows, which doesn't sound like what you want to happen. I think you may want to rethink how this workbook is going to be used.

Here's an example of hiding specific columns, which also contains the commands to unprotect and protect a sheet.

Sub Hide_Columns()

    Application.ScreenUpdating = False
    ActiveSheet.Unprotect

    Range("C:C,H:H,I:I,K:K,M:M,R:R,W:AH").EntireColumn.Hidden = True
    
    ActiveSheet.Protect
    Application.ScreenUpdating = True

End Sub

Then unhide them.

Sub Unhide_Columns()

    Application.ScreenUpdating = False
    ActiveSheet.Unprotect

    Range("C:C,H:H,I:I,K:K,M:M,R:R,W:AH").EntireColumn.Hidden = False
    
    ActiveSheet.Protect
    Application.ScreenUpdating = True

End Sub

Also note the Application.ScreenUpdating = True or False. This will eliminate any screen flicker or any movement at all that might be visible while the macro runs.

I'm afraid I don't know how to get these macros to react to a selection of the DV Lists though. I would just use buttons and assign the macros to them, running them when needed.

Hi Nephi,

You can't only hide the cells adjacent to the row you are on (E through K) without hiding the entire column for all rows on the sheet. Maybe some conditional formatting would better suit your needs? You could then cause the info for those columns on each row to change colors or fonts or whatever when Yes or No or Call Back is selected in column D on whichever row you are on at the time.