Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
i need to lock a document line by line so once information is entered it cant be changed. is there a excel formula for this or a program?
at work we use a daily occurence book. its a massive waste of paper. what i want to do is create a digital version that at the end of each line when yopu move to the next by pressing enter or ticking a box or whatever the previous line saves and cannot be changed, does anyone know of such a program
1 Answer
- garbo7441Lv 71 year ago
It could be done fairly easily in Excel using a VBA event handler without password protecting the workbook. This event handler will allow entry in any cell in A1:D20. Once an entry is made, it cannot be changed.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("A1:D20")) Is Nothing Then
If Target.Value <> "" Then
Range("IV1").Select
ActiveWindow.ScrollColumn = 1
End If
End If
End Sub
If you would like to pursue this method please drop an email to me at excelhelp@comcast.net. I don't charge for assistance.