?
Solved

minimize excel when macro is running.

Posted on 2005-04-06
4
Medium Priority
?
448 Views
Last Modified: 2008-03-17
The macro in excel sheet opens several .xls files. Is there a way to minimize the application while the macro is running. This shoud also minimize all the files that are opened while the macro is getting executed.

Thank you in advance.
0
Comment
Question by:Aiysha
  • 2
  • 2
4 Comments
 
LVL 55

Accepted Solution

by:
Jaime Olivares earned 2000 total points
ID: 13722199
just need this:
Application.WindowState = xlMinimized

0
 
LVL 55

Expert Comment

by:Jaime Olivares
ID: 13722360
Does it works?
0
 

Author Comment

by:Aiysha
ID: 13728614
No it didnt work
0
 

Author Comment

by:Aiysha
ID: 14155797
I set the application.visible =false ..this serves the purpose.

Thank you.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

839 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