View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Refresh screen method?

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??