Locking specific cells containing Macros

[TommyDaGun]

Hi Guys,


I need help to lock specific cells that contain Macros.

I've tried the following:-


Private Sub Worksheet_Change(ByVal Target As Range)

Dim MP_RowNumber, MP_ColNumber, MP_Row As Single

Dim YOURPASSWORD As Variant

YOURPASSWORD = ""

Worksheets("Main Working").Unprotect Password = ""


But with no luck. It comes uo with "Compile Error variant not found" and highlights "Password" and "Private Sub Worksheet_Change(ByVal Target As Range)

". I have time stamps that require protecting once data is entered if that makes sense?

Thanks,

Tom

 

[sgmpatnaik]

@Tommy


Hi


Firstly Welcome to Chandorg Forums, Glad you are here


not sure about your requirement but try the below link which will give some idea


http://chandoo.org/forums/topic/lock-excel-columns-contains-formulas


if any problem please refer us


Thanks


SP