Hello,

I would like to create a following functionality to my workbook. When the
user opens the Excel file he sees only inputbox for password but not the
contens of the activesheet in the Excel file. I have the following code:

Private Sub auto_open()
Dim answer As String
answer = InputBox("Insert password")
If answer = "abc" Then
Sheets("Sheet1").Activate
Else
ActiveWorkbook.Close
End If
End Sub

However, the problem is that now Excel already shows the information in the
active sheet and I would like to prevent this. Any ideas how to do this?

Best regards
Vepa