Solved

{WINDOWSOFF}  for Excel?

Posted on 1998-09-02
3
200 Views
Last Modified: 2012-06-27
For Excel 7.0a macros, is there an equivalent to Lotus 1-2-3's {WINDOWSOFF} and {WINDOWSON} pair?  They freeze and unfreeze the display while the macro is running (to save execution time, and to avoid annoying the user with flashing screen activity). I tried ActiveWindow.Visible = False, but then the next command (e.g., Range("A2").Select) gives an error -- as if the workbook did not exist. Is it even possible to work on a sheet when it is not visible?  
0
Comment
Question by:EDC
  • 2
3 Comments
 
LVL 5

Expert Comment

by:tuvi
ID: 1613407
Use these:

Application.ScreenUpdating = False 'turn off
Application.ScreenUpdating = True ' turn on

If the workbook is hidden, you have set variables to refer to your ranges before the workbook is hidden.

But if you can turn off screen display refresh, you probably don't need the hidden method.
0
 
LVL 5

Accepted Solution

by:
tuvi earned 70 total points
ID: 1613408
Use these:

Application.ScreenUpdating = False 'turn off
Application.ScreenUpdating = True ' turn on

If the workbook is hidden, you have set variables to refer to your ranges before the workbook is hidden.

But if you can turn off screen display refresh, you probably don't need the hidden method.

0
 

Author Comment

by:EDC
ID: 1613409
Fantastic!  Spot on; it works great.  
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Break numbering between parenthesis into a new line 32 56
Word - Access 3 48
Check version 13 68
Suggestions for Calendar app or system for a PC (not cloud-based) 8 78
In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

914 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now