Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
With Sheet2
.Visible = xlSheetVisible '取消隐藏
.Copy
ActiveWorkbook.SaveAs "c:\123"
ActiveWorkbook.Close
.Visible = xlSheetVeryHidden '再次隐藏
End With
End Sub 1.rar(8.7 KB, 下载次数: 18)
Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
With Sheet2
.Visible = xlSheetVisible '取消隐藏
.Copy
ActiveWorkbook.SaveAs "c:\123"
ActiveWorkbook.Close
.Visible = xlSheetVeryHidden '再次隐藏
End With
End Sub 1.rar(8.7 KB, 下载次数: 18)