你的代码只实现了你删不了我这个工作表,如果我想要sheet2也删不了的话却无法实现,我按你的方法在加上sheet2的话也只实现对一张表的操作,
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name = "你删不了我" Then ThisWorkbook.Protect Else ThisWorkbook.Unprotect
If Sh.Name = "Sheet2" Then ThisWorkbook.Protect Else ThisWorkbook.Unprotect
End Sub
是不是我加的代码是错的
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name = "你删不了我" or Sh.Name = "Sheet2"
Then ThisWorkbook.Protect
Else
ThisWorkbook.Unprotect
end if
End Sub