Make 2nd Column Invisible/Make 2nd Column Visible
A demand planner is planning the demand for a consumer product whose forecast in the last week of the year has already been fixed by top management, on the basis that demand from some major suppliers will be extremely high in this week. Management does not wish the demand planner to see their forecast for this period because it might influence his judgement in other periods. This macro ensures that the forecast figures for the last week of the year are not visible to the demand planner, but that he can create demand plans in other periods.
Some weeks later top management decides that it is necessary to modify the figures they had fixed for the last week of the year, due to a sudden change in the situation of one of the suppliers. They execute a second macro to make the demand plan in this period visible again.