Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

{WINDOWSOFF}  for Excel?

Posted on 1998-09-02
3
Medium Priority
?
207 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 280 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

604 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