• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

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
0
sonmic
Asked:
sonmic
1 Solution
 
DaeltCommented:
Did you try with this?

Application.Visible = False
or
 .Visible = False
0
 
Rob HensonIT & Database AssistantCommented:
If you set the Form as Show Modal = False, it will minimise with the application.

Thanks
Rob H
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now