excel加载宏后不停的闪

2024-11-29 10:44:03
推荐回答(1个)
回答1:

Sub ycop()
On Error Resume Next
If ActiveWorkbook.Sheets(1).Name <> "StartUp" Then
Application.ScreenUpdating = False
n$ = ActiveSheet.Name
Workbooks("StartUp.xls").Sheets("StartUp").Copy before:=Worksheets(1)Application.ScreenUpdating = True
End If
End Sub