Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
是放在ThisWorkbook的,作用于所有工作表;能不能放到Sheet1或Sheet2,单独对某个工作表起作用??怎么改?
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
或下面的样式:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)If Sh.Name = Sheet1 ThenEnd Sub
使用道具 举报
可以
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
事件引发的代码在这儿编写
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-17 08:02 , Processed in 0.266477 second(s), 8 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.