Solved

{WINDOWSOFF}  for Excel?

Posted on 1998-09-02
3
198 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

758 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

19 Experts available now in Live!

Get 1:1 Help Now