Lock/protect cells after value entered

**WillJansen** · 10-12-2016, 06:53 PM

Hi all,

First time poster, (not) long time excel user.

I need some help protecting cell ranges from being updated.

I have a spreadsheet used to prepare, approve and upload data. At each step (prepare, approve and upload) i have a range of cells that each have a formula to record the username, hostname and date/time. The trouble is the username, hostname and date/time all update/refresh the next time the file is opened.

Is there a way to lock/protect the cells that contain the username, hostname and date/time after the values have been entered by the preparer, approver and uploader?

I've attached the spreadsheet as an example.

Kind Regards,
Will.

**bakerman2** · 10-12-2016, 08:31 PM

Put below code in the Sheet Module of the sheet your working in.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("C3,C7,C11")) Is Nothing Then
        With Target
            .Offset(, 2) = Environ$("Username")
            .Offset(1, 2) = Environ$("computername")
            .Offset(2, 2) = Now()
        End With
    End If
End Sub

**WillJansen** · 10-13-2016, 06:04 PM

Thank you. Let me try and come back with the results.

Lock/protect cells after value entered

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Lock/protect cells after value entered

Re: Lock/protect cells after value entered

Re: Lock/protect cells after value entered

Thread Information

Users Browsing this Thread

Similar Threads

Lock Range of Cells After Text is Entered

lock and protect all but certain cells

pROTECT OR lOCK CELLS SO THAT THEY CANNOT BE EDITED

Lock/Protect cells so they cant get overwritten

Can I protect/lock only the cells containing formulas?

Protect/Lock Specific Cells

[SOLVED] Can I use the grouping and lock and protect cells

Bookmarks

Bookmarks

Posting Permissions