这个函数只对sheet1有效,在哪写对sheet1,2,3都有效.
6 个解决方案
#1
public
#2
模块中写 Public
#3
使用thisworkbook中的以下事件
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Excel.Range, Cancel As Boolean)
End Sub
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Excel.Range, Cancel As Boolean)
End Sub
#4
excel中用vba,1.Sheets("sheet1")中sheet1能用什么表明是当前sheet.就是点sheet1是Sheets("sheet1"),点sheet2是Sheets("sheet2").
这个问题帮忙解决一下.
这个问题帮忙解决一下.
#5
activesheet.name
#6
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object,
ByVal Target As Range, Cancel As Boolean)
End Sub
ByVal Target As Range, Cancel As Boolean)
End Sub
#1
public
#2
模块中写 Public
#3
使用thisworkbook中的以下事件
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Excel.Range, Cancel As Boolean)
End Sub
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Excel.Range, Cancel As Boolean)
End Sub
#4
excel中用vba,1.Sheets("sheet1")中sheet1能用什么表明是当前sheet.就是点sheet1是Sheets("sheet1"),点sheet2是Sheets("sheet2").
这个问题帮忙解决一下.
这个问题帮忙解决一下.
#5
activesheet.name
#6
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object,
ByVal Target As Range, Cancel As Boolean)
End Sub
ByVal Target As Range, Cancel As Boolean)
End Sub