ActiveX Control Button

[Mark]

In a spreadsheet an ActiveX control button has lost its original
appearance. Originally it looked like a nice rectangle with some text
inside it.
It was located at the top of a spreadsheet (around cell L1). There is
another control button at the top of the same sheet (around cell E1) -
but this one isn't ActiveX, it's created from the form menu and is
linked to a macro.

I used Freeze Frame on cell C5 and noticed a slow degradation in the
appearance of the ActiveX control button as the sheet was scrolled to
the far right.

Anyone have any ideas how to restore the appearance of the ActiveX
control button and how to keep it from changing appearance?

Let me try to describe the current appearance of the ActiveX control
button: text is no longer visible inside the area of the button; the
button's edges are faint; the button is comprised of some seemingly
randomly placed rectangles; the rectangles are different shades of
gray.

Thanks for any suggestions!

Mark

 

[Tom Ogilvy]

try throwing in an
Application.ScreenUpdating = False
Application.ScreenUpdating = True

in your code. Maybe in the selectionchange event.

 

[Mark Roach]

Thanks Tom. I'll give it a try.

Mark Roach
Vice President Technical Resources
The Oil & Gas Asset Clearinghouse
Houston, Texas