Make 2nd Column Read-Only/Make 2 nd Column Ready-For-Input
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 two major suppliers in this week will be extremely high. This macro ensures that the forecast figures in this period are not touched while the demand planner can apply forecasting techniques to 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 allow changes to be made to the demand plan in this period.