We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

{WINDOWSOFF}  for Excel?

EDC
EDC asked
on
Medium Priority
221 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?  
Comment
Watch Question

CERTIFIED EXPERT

Commented:
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.
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
EDC

Author

Commented:
Fantastic!  Spot on; it works great.  
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.