![]() |
#2
|
|||
|
|||
![]()
Paste this into the Sheet Level module for the worksheet.
Code:
Private Sub Worksheet_Change(ByVal Target As Range) Dim MyRange As Range Set MyRange = Intersect(Range("A1:D100"), Target) '<-- change range of rows here If Not MyRange Is Nothing Then Sheets("Sheet1").Unprotect password:="hello" '<-- this is your password, change as required. MyRange.Locked = True Sheets("Sheet1").Protect password:="hello" End If End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How Do You Drag & Drop Cells in Excel 2010? | juliansdad | Excel | 4 | 12-05-2013 01:15 AM |
Linking cells on Excel 2010 | teza2k06 | Excel | 1 | 02-05-2013 01:03 AM |
![]() |
tinfanide | Excel Programming | 8 | 04-08-2012 09:58 PM |
Protect / Lock Cells / Print Set-up? | meggenm | Excel | 3 | 01-26-2012 09:57 PM |
Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |