I have a question. The dutch forum coudn't help me out, so i'm posting this here.
I have a protected Excel-sheet with a table in it. Users can add data to the table and insert and deletes rows.
I have already a working VBA to insert (and delete) a row. But i won't copy the formula from the cell above (this case J24).
screenshot: screenshot
The VBA is:
Private Sub CommandButton1_Click()
ActiveSheet.Unprotect Password:="password"
ActiveSheet.ListObjects("Tabel2").ListRows.Add AlwaysInsert:=True
ActiveSheet.Protect Password:="password"
End Sub
Private Sub CommandButton2_Click()
ActiveSheet.Unprotect Password:="password"
ActiveSheet.ListObjects("Tabel2").ListRows(ActiveSheet.ListObjects("Tabel2").ListRows.Count).Delete
ActiveSheet.Protect Password:="password"
End Sub
What do I have to add to make it work?
Could some-one help me?
Many thanks!!!!
Aucun commentaire:
Enregistrer un commentaire