Dear Team,
I want to hide all my work sheets while opening the excel file and show only my userform. I tried the following code for that
Code
Private Sub Workbook_Open()
Dim i As Long
For i = 1 To 17
Sheets(i).Visible = xlVeryHidden
Next i
SelectChoice.Show
End Sub
But it is not hiding all the sheets. One sheet is viable by default and my code is showing error.
Can any one guide me for this.
I am attaching my file here for your reference