great work Vraag, in the end i ended up using the below code.
![]()
Private Sub Workbook_Open() On Error Resume Next For Each sh In Sheets Dim StrName As String StrName = UCase(Environ("UserName")) If sh.Name = "Team Dash" Or sh.Name = StrName Then sh.Visible = True Else sh.Visible = xlSheetVeryHidden Next sh End Sub
Bookmarks