use cannot change data after closing file

[faizee]

Dear Sir,

my user enters data in one file. which has 5 column table..
i want when he/she closes the file after entered all data,. then after that he/she could not change any previouse entry..

only authorised person could do that..


is that possible?

 

[mikerickson]

Perhaps putting something like this in the ThisWorkbook code module

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Sheet1.Protect "password", contents:=True
    Me.Save
End Sub

 

[faizee]

please also guide me how and where to enter it.

 

[mikerickson]

It is a BeforeClose event that goes in the ThisWorkbook code module.

 

[faizee]

no. its not working,,

 

[mikerickson]

Is the sheet's code name correct? Does the re-opened worksheet have a protected sheet?
What are the details of "doesn't work"?