1、VBA实现Excel工作簿只显示指定工作表
Private Sub Workbook_Open()
Dim sht As Worksheet
For Each sht In Me.Worksheets
If Not sht Is Worksheets("主界面")Then sht.Visible=xlSheetHidden
Next
End Sub
1、VBA实现Excel工作簿只显示指定工作表
Private Sub Workbook_Open()
Dim sht As Worksheet
For Each sht In Me.Worksheets
If Not sht Is Worksheets("主界面")Then sht.Visible=xlSheetHidden
Next
End Sub
本文标题：vba
本文链接：https://www.haomeiwen.com/subject/ykubohtx.html
网友评论