How do I protect cells once data input.

[ghrek]

Hi I have posted on here but dont understand. How do I lock cells once data input [SOLVED]

What it is I have a workbook that already has protected cells but what im trying to do is when data is input into UNPROTECTED cells I need them protected too.

When I clear on clear cells macro I need the ones that were protected to be unprotected and cleared.

All the cells that are unprotected and need protecting when data input are in bold borders.

Any Ideas? Link to workbook below...

Copy of Copy of CubicSheet V1.3 (3).xlsm

Microsoft Excel Workbook

1drv.ms

 

[Oddball2020]

Hope this helps as some examples how to unlock and lock sheets w/ password protection in VBA:

'Unlock all sheets in workbook
    Dim i As Long
    
    For i = 1 To Sheets.Count
        Sheets(i).Unprotect Password = "Password"
    Next i


'Locks Certain Cells or Ranges

Worksheets("Summary").Range("F7").Locked = False    'use before if there's cells you don't want locked, otherwise skip

Sheets("Summary").Protect Password = "Password"   'lock using password in macro

 

[Fluff]

@Oddball2020
In what way has that got anything to do with the OP's request?

 

[Oddball2020]

@Oddball2020
In what way has that got anything to do with the OP's request?

He's talking about locking/unlocking cells on the sheet... I assumed he would be using VBA as a solution. I know I didn't solve it for him, but was just providing some VBA that he could use along those lines if he wanted. If it's not an appropriate post, please delete it, thanks!