Pozadovane lze resit takto:
Na prislusnem listu (list1) zrusit uzamceni bunek v pozadovane oblasti (napr.: A1:E20 a G1:G20).
V editoru VBA (Alt+F11) vlozit procedury:
do modulu Tento_sesit - heslo je "password" (bez uvozovek) - zmenit, heslo neni podminku, lze pripadne vynechat:
Option Explicit
Private Sub Workbook_Open()
Worksheets("list1").Protect Password:="password", UserInterfaceOnly:=True
End Sub
a do modulu prislusneho listu - list1:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Set Target = Target.Resize(1, 1)
If Not Intersect(Me.Range("a1:e20,g1:g20"), Target) Is Nothing Then
Target.Locked = True
End If
End Sub
Po zapisu do bunky v pozadovane oblasti bude bunka uzamknuta.