VBA Lock and unlock a sheet.

[Genetu]

I have a sheet with a formula and there is a VBA code run on it. The formula should be hidden (protected). When the code is run it can not change the Vloockup value of the cell. The first value is continued till the end. When the formula is unprotected everything is OK. But I need the formula to be hidden. This is the step I trying to fix.

Sub vlookup_Value()
     'Unprotect the sheet and formula

            'Any code .........

    'Protect sheet and cells with the formula
End sub

 

[Genetu]

Sanjeev1976 great job the only thing left is unprotecting other cells except for formulas. Check the code; perfectly run the main code after unprotecting the sheet, through "execute code". But other cells could not accept any data. The dialogue box "The cell you are trying to change is protected...".

 

[Sanjeev1976]

Sanjeev1976 great job the only thing left is unprotecting other cells except for formulas. Check the code; perfectly run the main code after unprotecting the sheet, through "execute code". But other cells could not accept any data. The dialogue box "The cell you are trying to change is protected...".

You need to tell exactly what you want to do with the other cells. This code unprotects the sheet performs what is mentioned in the Execute Code and then protects the sheet again.

Whatever you need to do should be part of the Execute Code or else you can simply unprotect the sheet and continue with what needs to be done.

 

[Genetu]

You need to tell exactly what you want to do with the other cells. This code unprotects the sheet performs what is mentioned in the Execute Code and then protects the sheet again.

Whatever you need to do should be part of the Execute Code or else you can simply unprotect the sheet and continue with what needs to be done.

Ok, Sir. What I need is a sheet that has a formula. The formula must not be edited but hidden (not shown on the formula bar). To do that the sheet must be protected. Other cells, except formula cells, should accept and edit any value. In the execute code, if [A1], [A2], and [A4] values were typed on the cell, you can't after running the code twice. But this is done manually but I need to do this in VBA.
All formulas are hidden and protected, other cells should accept & edit any data even after running the code many times. This is what I want, Sanjeev1976. Thank you in advance.

 

[Sanjeev1976]

Select the entire sheet and format all the cells except cells [A1], [A2], and [A4] as unlocked and not hidden and only the cells [A1], [A2], and [A4] as locked and hidden. Then you are good to go with the current VBA code