ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Missing Command Buttons (https://www.excelbanter.com/excel-programming/336691-missing-command-buttons.html)

Bigjayce[_11_]

Missing Command Buttons
 
I have Office 2003 with SP1 installed from clean on my PC, I created a few
spreadsheets on Office XP and now need to make some mods, I copied them to
this PC but the command buttons are not showing up, not only that but if I
create a new worksheet and try to draw a new commandbutton there is no back
ground to it.

The sheets still work on the old version of Excel but not 2003 - does anyone
know if I need to add a reference or something like that ?

Its driving me crazy

Jayce

Jim Rech

Missing Command Buttons
 
Check your Tools, Options, View setting for displaying Objects.

--
Jim
"Bigjayce" wrote in message
...
|I have Office 2003 with SP1 installed from clean on my PC, I created a few
| spreadsheets on Office XP and now need to make some mods, I copied them to
| this PC but the command buttons are not showing up, not only that but if I
| create a new worksheet and try to draw a new commandbutton there is no
back
| ground to it.
|
| The sheets still work on the old version of Excel but not 2003 - does
anyone
| know if I need to add a reference or something like that ?
|
| Its driving me crazy
|
| Jayce



Bigjayce[_11_]

Missing Command Buttons
 
Hi,

Its set to display all so that would seem ok.

A little more info on the problem:

If I try to draw a new command button on a new sheet, no matter how big I
draw it it snaps back to being 4 small circles, if I grab one of these and
enlarge it there is no background jsut an empty shape with a red x in the top
corner - like it can't find a backgroud :s

Time to call the men in the white van with my special coat

Jayce




"Jim Rech" wrote:

Check your Tools, Options, View setting for displaying Objects.

--
Jim
"Bigjayce" wrote in message
...
|I have Office 2003 with SP1 installed from clean on my PC, I created a few
| spreadsheets on Office XP and now need to make some mods, I copied them to
| this PC but the command buttons are not showing up, not only that but if I
| create a new worksheet and try to draw a new commandbutton there is no
back
| ground to it.
|
| The sheets still work on the old version of Excel but not 2003 - does
anyone
| know if I need to add a reference or something like that ?
|
| Its driving me crazy
|
| Jayce




Jim Rech

Missing Command Buttons
 
Time to call the men in the white van with my special coat

I'm sure you're not crazy but I have no idea what's going on, sorry.

--
Jim
"Bigjayce" wrote in message
...
| Hi,
|
| Its set to display all so that would seem ok.
|
| A little more info on the problem:
|
| If I try to draw a new command button on a new sheet, no matter how big I
| draw it it snaps back to being 4 small circles, if I grab one of these and
| enlarge it there is no background jsut an empty shape with a red x in the
top
| corner - like it can't find a backgroud :s
|
| Time to call the men in the white van with my special coat
|
| Jayce
|
|
|
|
| "Jim Rech" wrote:
|
| Check your Tools, Options, View setting for displaying Objects.
|
| --
| Jim
| "Bigjayce" wrote in message
| ...
| |I have Office 2003 with SP1 installed from clean on my PC, I created a
few
| | spreadsheets on Office XP and now need to make some mods, I copied
them to
| | this PC but the command buttons are not showing up, not only that but
if I
| | create a new worksheet and try to draw a new commandbutton there is no
| back
| | ground to it.
| |
| | The sheets still work on the old version of Excel but not 2003 - does
| anyone
| | know if I need to add a reference or something like that ?
| |
| | Its driving me crazy
| |
| | Jayce
|
|
|




All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com