Hi dornan,
It's possible to make Excel application minimise, but other people can see the spread sheet if they click the Excel icon on Task bar.
So, you don't want to show the spread sheet, why don't you make a blank sheet and hide other spread sheet?
Here is thecode I wrote just as sample.
To see other spread sheet, double click on the Dummy sheet and enter password.
This time, password is "password". And please note, make sure protect the VBAProject.
<pre>
'Put these code on Thisworkbook modele
Const PASSWORD As String = "password" 'change this as you like
Const strDummyWs As String = "Dummy" 'change this as you like
Dim wsDummy As Worksheet
Dim ws As Worksheet
Private Sub Workbook_Open()
Set wsDummy = Sheets.Add
On Error Resume Next
Application.DisplayAlerts = False
Sheets(strDummyWs).Delete
Application.DisplayAlerts = True
On Error GoTo 0
wsDummy.Name = strDummyWs
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> wsDummy.Name Then
ws.Visible = xlSheetVeryHidden
End If
Next
Set wsDummy = Nothing
End Sub
Private Sub Workbook_SheetBeforeDoubleClick _
(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Dim strPw As String
If Sh.Name <> "Dummy" Then Exit Sub
strPw = InputBox("Please inoput password")
If strPw <> PASSWORD Then Exit Sub
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> strDummyWs Then
ws.Visible = xlSheetVisible
Else
Set wsDummy = ws
End If
Next
Application.DisplayAlerts = False
wsDummy.Delete
Application.DisplayAlerts = True
Set wsDummy = Nothing
End Sub
</pre>