GauravS313530
New Member
Hi All, I don't get any solution in google for below scenario.
In attached excel, there are 2 dropdown list in sheet "Home" and I want to Protect/Unprotect "Data Sheet" columns basis on these dropdown values.
when I select "Budget" in dropdown then it will Unprotect columns(from F to Q) in Data sheet means all columns are editable. and when I select "Forecast" In dropdown then It will start Protecting Columns basis on Second dropdown List Value. for ex.- If I Select "Forecast" and "May" in Dropdown then It will Protect columns (F to I) so that No one can change the data in these columns (F to I). If I select "Forecast" and "Nov" In dropdown , it will Protect columns (F to O) so that these are not editable.
Protection can with/without password protected.
Request all to Please help with the solution.
In attached excel, there are 2 dropdown list in sheet "Home" and I want to Protect/Unprotect "Data Sheet" columns basis on these dropdown values.
when I select "Budget" in dropdown then it will Unprotect columns(from F to Q) in Data sheet means all columns are editable. and when I select "Forecast" In dropdown then It will start Protecting Columns basis on Second dropdown List Value. for ex.- If I Select "Forecast" and "May" in Dropdown then It will Protect columns (F to I) so that No one can change the data in these columns (F to I). If I select "Forecast" and "Nov" In dropdown , it will Protect columns (F to O) so that these are not editable.
Protection can with/without password protected.
Request all to Please help with the solution.