Hide Excel Window

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

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.
 
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.
Click to expand...
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Floating text 1
how to reshow userform after following a link 1
To protect user's privacy 1
Hide the close X in excel 2
Hide form page 1
HELP: Application.Visible issue - only hide workbook that has user 4
How to hide excel? 1
Hide column based on data validation 0

Back
Top