Solved

Minimize an excel with userform

Posted on 2011-09-05
2
283 Views
Last Modified: 2012-05-12
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
Comment
Question by:sonmic
2 Comments
 
LVL 4

Expert Comment

by:Daelt
ID: 36483148
Did you try with this?

Application.Visible = False
or
 .Visible = False
0
 
LVL 33

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 36483283
If you set the Form as Show Modal = False, it will minimise with the application.

Thanks
Rob H
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question