Refresh screen method?

R

Robert Crandal

When I run a script that password protects all of my sheets, I
noticed that some of the data on my screen is incorrect or
inconsistent with the workbook. However, if I minimize
the Excel application and then restore it, I notice that
everything looks as it should.

This leads me to my question: Is there some sort of "screen
refresh" method that I need to use after I password protect
all my sheets?? I saw a method called "RefreshAll", but
I dont have a clue what that's for?? Which method is
best used to refresh the screen or application??
 
O

OssieMac

Hi Robert,

Without access to your particular worksheet I don't know if this will help
or not.

Try F9 to re-calculate

or in VBA code

Calculate
 
R

Rick Rothstein

If OssieMac's suggestion doesn't work for you, then does your "script", or
any other code you run in conjunction with it, ever execute this line of
code?

Application.ScreenUpdating = False

If so, then my guess is you didn't take steps to set the property back to
True before your code ceased executing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top