edit cells only with authority

[zhj23]

Hi Freinds

A protected worksheet with some unlocked cells which allowed users to input
data. Once it is inputted, how could we control the subsequent editing of
these cells only by authorised personnel/password?

Thank you.

[Rowan]

You could use a sheet event to lock cells once they have been edited. Right
click the sheet tab and select View Code. Paste this macro onto the code
module for the sheet and change the password as required.

Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Unprotect Password:="mypassword"
Target.Locked = True
ActiveSheet.Protect Password:="mypassword"
End Sub

Hope this helps
Rowan

"zhj23" wrote:

> Hi Freinds
>
> A protected worksheet with some unlocked cells which allowed users to input
> data. Once it is inputted, how could we control the subsequent editing of
> these cells only by authorised personnel/password?
>
> Thank you.