å³é®å·¥ä½è¡¨æ ç¾,æ¥ç代ç ,å°ä¸é¢ç代ç ç²è´´å°ç©ºç½çåºå(代ç çªå£)
å·¥ä½è¡¨ä¿æ¤å¯ç 为123,å¯ä»¥æ ¹æ®èªå·±å好,æ´æ¹è¿ä¸ªå¯ç ,ä½ååå¿
é¡»ä¸è´
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Unprotect Password:="123"
Target.Locked = True
Target.FormulaHidden = True
ActiveSheet.Protect Password:="123"
End Sub
温馨提示:答案为网友推荐,仅供参考