如何用vba实现excel打开时默认打开以当前日期命名的工作表?例如:今天是3...

2024-11-24 04:36:54
推荐回答(2个)
回答1:

Private Sub Workbook_Open()
For Each sh In ThisWorkbook.Sheets
If sh.Name *1 = Format(Date, "D")*1 Then
sh.Activate
Exit For
End If
Next
end sub

回答2:

遗憾,被人抢答