insomniac53
Board Regular
- Joined
- Sep 3, 2013
- Messages
- 104
I can switch off worksheet tabs by adding the following code to the Activate sub of each worksheet.
but if I try looping through all the sheets like this:
it doesn't work.
Can anyone tell me what's wrong? Thanks
Code:
ActiveWindow.DisplayWorkbookTabs = False
Code:
Sub SwitchOffAllTabs()
Dim w As Worksheet
ScreenUpdating = False
For Each w In ThisWorkbook.Sheets
w.Activate
ActiveWindow.DisplayWorkbookTabs = False
Next
ScreenUpdating = True
MsgBox "Done"
End Sub
Can anyone tell me what's wrong? Thanks