Hide Excel Window
 

I have small application which ask user for enty on the form, processes text
file, created output files and closes. All works fine but I would like to
hide Excel so that after clicking on shortcut user will only see the entry
form and after running the process confirmation of completion. I can not
figure out on how to hide Excel and still have the entry form visible. How it
can be done.

Thanks for advise.

Hide Excel Window
 

On Feb 17, 5:41*pm, Tony wrote:
I have small application which ask user for enty on the form, processes text
file, created output files and closes. All works fine but I would like to
hide Excel so that after clicking on shortcut user will only see the entry
form and after running the process confirmation of completion. I can not
figure out on how to hide Excel and still have the entry form visible. How it
can be done.

Thanks for advise.
Try these command in the UserForm


Private Sub CommandButton1_Click()
'makes excel visible and closes unloads the workbook
Application.Visible = True
Unload Me
End Sub

Private Sub UserForm_Initialize()
'makes excel invisible
Application.Visible = False
End Sub