Excel 2003 dissapearing buttons

[howamidifferent]

I upgraded recently from Office XP to Office 2003.
One of my workbooks stored on my local drive contained six command buttons
on the worksheet which each called a macro stored in the workbook not in the
personel.xls.

After upgrade, when I open the file, I see all of the buttons for a fraction
of a second then they dissapear.
The macros are still in the workbook, the on_click code for the buttons
which call the macros is also still there but the buttons disappear.

By clicking around the area where the buttons should be one of them suddenly
becomes visible, does its thing and disapears again.
I've checked its properties and it is set to visible, I also chose bring to
front but it still disapears. The other 5 buttons never seem to appear.
Any one have any idea whats happening here. I tried to delete them and
re-add but this causes the on_click code to be deleted from the workbook so
I closed without saving.

 

[Jim Rech]

Any chance "Hide all" is set under Tools, Options, View, Objects?

 

[howamidifferent]

Tried that but no...thanks anyway...
I also found a file called Excel10.xlb and Exel11.xlb. I deleted Excel11.xlb
and renamed the other but no joy...Saw somewhere this affects buttons..

Any chance "Hide all" is set under Tools, Options, View, Objects?

I upgraded recently from Office XP to Office 2003.
One of my workbooks stored on my local drive contained six command buttons
on the worksheet which each called a macro stored in the workbook not in the
personel.xls.

After upgrade, when I open the file, I see all of the buttons for a fraction
of a second then they dissapear.
The macros are still in the workbook, the on_click code for the buttons
which call the macros is also still there but the buttons disappear.

By clicking around the area where the buttons should be one of them suddenly
becomes visible, does its thing and disapears again.
I've checked its properties and it is set to visible, I also chose bring to
front but it still disapears. The other 5 buttons never seem to appear.
Any one have any idea whats happening here. I tried to delete them and
re-add but this causes the on_click code to be deleted from the workbook so
I closed without saving.

 

[Dave Peterson]

The only time I've seen buttons on the worksheet disappear is when I'm low on
resources.

Can you try closing all the other open applications and then open excel and see
if that helps.

(Sometimes minimizing the workbook and resizing helps. Sometimes minimizing
Excel and then resizing that helps, too.)

And just for the heck of it, close excel and try cleaning up your windows Temp
folder.

 

[howamidifferent]

No joy either...anyone???????

The only time I've seen buttons on the worksheet disappear is when I'm low on
resources.

Can you try closing all the other open applications and then open excel and see
if that helps.

(Sometimes minimizing the workbook and resizing helps. Sometimes minimizing
Excel and then resizing that helps, too.)

And just for the heck of it, close excel and try cleaning up your windows Temp
folder.