View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Screen artefacts

Are you using

Application.screenupdating = False / True

I have had that leave artifacts. You may need to toggle the updating on and
off to get the screen to refresh. If you are in a form you may need to
repaint it?

That is my two cents

HTH

"UKNewbie" wrote:

Hi there,

Has anyone experienced screen artefacts when hiding/unhidind command buttons
i.e.
- the button is still visible although you've hidden it
- you cannot select it
- if you move your selection are away from the artefact and go back, it's
gone.

If anyone has, do you know how to prevent this rather annoying issue.

I've programatically changed my selection area away from and back to - no joy.
If I change the worksheet selection away from and back, that works but is
not a suitable solution.

Any help, as always, would be muchly appreciated.

TIA

Mike

(Excel 97 on NT4 workstation)