VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
END
Attribute VB_Name = "List2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = True
Dim MinulyId
Dim MinulyRadek
Dim MinulySloupec
Dim MinulyTarget
Dim MinulyValue
Dim MinulaTabulka
Dim Prepinac


Private Sub Worksheet_Activate()
MinulaTabulka = ActiveSheet.Name
Prepinac = 0
cteni (MinulaTabulka)
Prepinac = 1
End Sub

Private Sub Worksheet_Deactivate()
MsgBox ActiveSheet.Name & "deactivate"
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)

If Prepinac = 0 Then
    GoTo Konec
End If

If MinulyTarget = Target.Value Then
    GoTo Konec
End If

If MinulySloupec = 1 And MinulyTarget = "" Then
    MsgBox "přidat řádek"
'    IF no ok then Target.Value=MinulyTarget
    GoTo Konec
End If

If MinulySloupec = 1 And MinulyTarget <> "" And Target.Value <> "" Then
    MsgBox "změnit radek"
'    IF no ok then Target.Value=MinulyTarget
    GoTo Konec
End If

If MinulySloupec = 1 And MinulyTarget <> "" And Target.Value = "" Then
    MsgBox "vymazat radek"
    GoTo Konec
End If

If MinulySloupec <> 1 And MinulyTarget <> "" Then
     MsgBox "změnit radek"
'    IF no ok then Target.Value=MinulyTarget
    GoTo Konec
End If

Konec:
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MinulyTarget = Target.Value
MinulyRadek = Target.Row
MinulySloupec = Target.Column
MinulyId = ActiveSheet.Cells(MinulyRadek, 1)
End Sub
