Vanishing Control Toolbox Command Buttons
 

I have recently had my work PC upgraded from Windows NT to XP, and am now
using Excel 2003 rather than 97.

A spreadsheet I use each day contains a number of command buttons (from the
control toolbox menu rather than forms). When I open this spreadsheet I
cannot see the buttons. If I click on where the buttons are they still work,
and I can still see the code behind them, but I cannot see the buttons
themselves.

Similarly if I try to create a new command button - or indeed any control -
from the control toolbox I get the same problem. But again I am able to
create buttons from the forms toolbar with no problem.

I'm guessing some setting is wrong somewhere, but I have no idea which one!
I'd be grateful if anyone could assist.

Thanks.

"Fritz24" wrote:

I have recently had my work PC upgraded from Windows NT to XP, and am now
using Excel 2003 rather than 97.

A spreadsheet I use each day contains a number of command buttons (from the
control toolbox menu rather than forms). When I open this spreadsheet I
cannot see the buttons. If I click on where the buttons are they still work,
and I can still see the code behind them, but I cannot see the buttons
themselves.

Similarly if I try to create a new command button - or indeed any control -
from the control toolbox I get the same problem. But again I am able to
create buttons from the forms toolbar with no problem.

I'm guessing some setting is wrong somewhere, but I have no idea which one!
I'd be grateful if anyone could assist.


Presumably, your company's helpdesk couldn't figure it out. Have you tried
looking at the properties for the control to see if there's anything which
may cause the invisibility?

I always thought that this kind of problem was more of a
windows/graphics/display problem.

Sometimes, I can minimize the worksheet window and then maximize it and the
controls are back.

Sometimes, I can minimize the application and then maximize it and that works,
too.

Sometimes, closing and reopening works.

But if I have my choice, I'll use the objects from the Forms toolbar. They seem
to behave much better on a worksheet.

Fritz24 wrote:

I have recently had my work PC upgraded from Windows NT to XP, and am now
using Excel 2003 rather than 97.

A spreadsheet I use each day contains a number of command buttons (from the
control toolbox menu rather than forms). When I open this spreadsheet I
cannot see the buttons. If I click on where the buttons are they still work,
and I can still see the code behind them, but I cannot see the buttons
themselves.

Similarly if I try to create a new command button - or indeed any control -
from the control toolbox I get the same problem. But again I am able to
create buttons from the forms toolbar with no problem.

I'm guessing some setting is wrong somewhere, but I have no idea which one!
I'd be grateful if anyone could assist.

Thanks.

--

Dave Peterson