Minimize an excel with userform

Hi,

I have an excel with a userform, but i can't minimize the whole application.
I found on this forum the code
   With Application
     .WindowState = xlNormal
     .Top = 175  '< Adapt/Improve to handle resolutions
     .Left = 250 '< Same
     .Height = 1
     .Width = 1
     UserForm1.Show '< Adapt
     .WindowState = xlMinimized
   End With
but it doesn't work.
What i'am doing wrong?
Tx
sonmicAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
If you set the Form as Show Modal = False, it will minimise with the application.

Thanks
Rob H
0
 
DaeltCommented:
Did you try with this?

Application.Visible = False
or
 .Visible = False
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.