Pinaceous
Well-known Member
- Joined
- Jun 11, 2014
- Messages
- 1,113
- Office Version
- 365
- Platform
- Windows
Hi All,
If I'm working with the following Sub that acts upon a specific sheet name its "TAB NAME", do you know how I can change this to a worksheet number?
Thank you for your help!
pinaceous
If I'm working with the following Sub that acts upon a specific sheet name its "TAB NAME", do you know how I can change this to a worksheet number?
VBA Code:
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Name <> "Tab1 Name" Then
'Change "TAB NAME"
If ws.Name <> "Tab2 Name" And ws.Name <> "Tab1 Name" Then
ws.visible = xlSheetHidden
Application.ScreenUpdating = False
End If
Next
Thank you for your help!
pinaceous
Last edited: