Hi Guys,
Need some help with a VBA. I have a sheet with 7 columns A:G. multiple rows will be used. I need only certain cells unprotected when specific cell is used. and when another cell is used other cells should be locked and others unprotected. Below scenarios will apply, but only one instance of the scenario at a time. If the user uses the 1st scenario that will be the only scenario used on the spreadsheet. if the 2nd scenario is used. only the second scenario will be used for the whole sheet.
Scenarios
If Column C has an "X" only 3 columns should be allowed to be used Columns A,B and D and be made compulsory. The others locked for all rows.
If Column G has an "X" only 2 Columns should be used and compulsory Columns A and B, the others should be locked.
If Column F is used only column A should be used and be compulsory. All others should be locked for all rows
If Column E is used only columns A and B should be used and be made compulsory. All others should be blocked for all rows
Need some help with a VBA. I have a sheet with 7 columns A:G. multiple rows will be used. I need only certain cells unprotected when specific cell is used. and when another cell is used other cells should be locked and others unprotected. Below scenarios will apply, but only one instance of the scenario at a time. If the user uses the 1st scenario that will be the only scenario used on the spreadsheet. if the 2nd scenario is used. only the second scenario will be used for the whole sheet.
Scenarios
If Column C has an "X" only 3 columns should be allowed to be used Columns A,B and D and be made compulsory. The others locked for all rows.
If Column G has an "X" only 2 Columns should be used and compulsory Columns A and B, the others should be locked.
If Column F is used only column A should be used and be compulsory. All others should be locked for all rows
If Column E is used only columns A and B should be used and be made compulsory. All others should be blocked for all rows