|
本帖最后由 qjsu 于 2013-6-6 16:37 编辑
Sub 工作表重命名()
Dim I
Dim Y
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim sh As Worksheet
For Each sh In Sheets
I = sh.Name
IF NOT I LIKE "[汇总,Sheet1]" then
Y = Mid(I, 1, 5)
sh.Name = Y
End If
Next
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
- Sub 工作表重命名()
- Dim I As String
- Dim Y As String
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Dim sh As Worksheet
- For Each sh In Sheets
- I = sh.Name
- Select Case I
- Case "汇总", "Sheet1"
- Case Else
- Y = Mid(I, 1, 5)
- sh.Name = Y
- End Select
- Next
- Application.ScreenUpdating = True
- Application.DisplayAlerts = True
- End Sub
复制代码多工作表时,小心后面重命名失败。
|
|