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)

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)

I'm not using them. I'll try to use it at the end of the macro to see if it
helps.

Any other theories would be welcomed too.

Thanks, Jim.

"Jim Thomlinson" wrote:

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)