Most valuable professional
  • Hot Topics

Excel EntireColumn.Hidden doesn't work in Worksheet_Change()

Hi there, this is my first post as I've been tweaking and hunting for a couple of days and I haven't been able to find a resolution here or elsewhere. Using Excel 2010 I am editing an existing unprotected workbook and have created EntireColumn.Hidden and EntireRow.Hidden commands in the Worksheet_Change() event to fire when a Data Validation cell is changed, but they don't work. Code: Private With Application .ScreenUpdating = False .EnableEvents = False End With If Not Intersect(Target, Range("$C$2")) Is Not Select Case Target.Value Case "NO" MsgBox "You just changed to HIDE" Range("$C$3").Value = "Invisible" Columns("N:O").EntireColumn.Hidden Case "YES" MsgBox "You just changed to UNHIDE Range("$C$3").Value = "Visible" Columns("N:O").EntireColumn.Hidden End Select End If With Application .ScreenUpdating = True .EnableEvents = True End With

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of June 9, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel