Please open the excel file first. The macro is running a bit strange: scenario 1 should go all the way to column V, scenario 2 to column U, scenario 3 to column M, and scenario 4 should show all the columns in the workbook - try switching among the scenarios and see if this happens. Scenarios can be changed en cell A9.
The macro below already hides the columns where row <> 1. What could be added to the macro first "shows"/unhides all columns, then it hides the columns. Because I will be chaning which columns will show and hide, I need to ensure that the macro "resets" itself.