KlausW
Active Member
- Joined
- Sep 9, 2020
- Messages
- 445
- Office Version
- 2016
- Platform
- Windows
Hi everyone
I would like to use this VBA-code so that it hides all sheets except those standing in
But it doesn’t do it, someone who can help.
All help will be appreciated.
Best Regards
Klaus W.
I would like to use this VBA-code so that it hides all sheets except those standing in
VBA Code:
ws.Names = Array("Højde", "VPL", "Fast besætning", "Adresseliste Fast og VPL", "Adresseliste")
But it doesn’t do it, someone who can help.
All help will be appreciated.
Best Regards
Klaus W.
VBA Code:
Sub Hide()
Dim ws As Worksheet
ws.Names = Array("Højde", "VPL", "Fast besætning", "Adresseliste Fast og VPL", "Adresseliste")
For Each ws In ws.Names
If ws.Name <> ws.Names Then
wsNames.Visible = xlSheetHidden
Next ws
End If
End Sub