ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Command button no displaying (https://www.excelbanter.com/excel-programming/388486-command-button-no-displaying.html)

Dawson

Command button no displaying
 
Hello,

I create and maintain a spreadsheet that many different people use
individual copies of across multiple terminal environments. In this
spreadsheets I have placed different command buttons. But for one of
terminal environments with Excel 2003 SP2 the command buttons will not
display. In the other 2 terminal environments (with excel 2000 sp3 and excel
2003 sp2) the buttons display fine. I can't seem to figure out why it won't
display in the first environment. All the buttons are enabled and have the
visibility set to true. I created the spreadsheet with excel 2000 sp3 if
that makes a difference somehow.

My question is :

Does anyone have any suggestions for things to check that might cause a
problem like I described above? or might I be overlooking something obvious?

Thanks in advance for any replies.

dq

Command button no displaying
 
Are you sure macro's are enabled for this user?

DQ


Dawson

Command button no displaying
 
Yes, macros are enabled. This was the first thing that I checked as I was
sure that would be it, but unfortunately it wasn't.

thanks for the suggestion.



"dq" wrote:

Are you sure macro's are enabled for this user?

DQ



JLGWhiz

Command button no displaying
 
Check OptionsView:Objects to see if Show All is checked or Hide All is
checked.

"dawson" wrote:

Hello,

I create and maintain a spreadsheet that many different people use
individual copies of across multiple terminal environments. In this
spreadsheets I have placed different command buttons. But for one of
terminal environments with Excel 2003 SP2 the command buttons will not
display. In the other 2 terminal environments (with excel 2000 sp3 and excel
2003 sp2) the buttons display fine. I can't seem to figure out why it won't
display in the first environment. All the buttons are enabled and have the
visibility set to true. I created the spreadsheet with excel 2000 sp3 if
that makes a difference somehow.

My question is :

Does anyone have any suggestions for things to check that might cause a
problem like I described above? or might I be overlooking something obvious?

Thanks in advance for any replies.


JLGWhiz

Command button no displaying
 
That should be ToolsOptionsView:Objects

"dawson" wrote:

Hello,

I create and maintain a spreadsheet that many different people use
individual copies of across multiple terminal environments. In this
spreadsheets I have placed different command buttons. But for one of
terminal environments with Excel 2003 SP2 the command buttons will not
display. In the other 2 terminal environments (with excel 2000 sp3 and excel
2003 sp2) the buttons display fine. I can't seem to figure out why it won't
display in the first environment. All the buttons are enabled and have the
visibility set to true. I created the spreadsheet with excel 2000 sp3 if
that makes a difference somehow.

My question is :

Does anyone have any suggestions for things to check that might cause a
problem like I described above? or might I be overlooking something obvious?

Thanks in advance for any replies.


Dawson

Command button no displaying
 
Thanks for the suggestion. I took a look there and Show All is selected.

I tried toggling them back and forth to see if that would trigger the
buttons to show up on the screen, but it didn't help.

I will keep searching thanks again.

"JLGWhiz" wrote:

Check OptionsView:Objects to see if Show All is checked or Hide All is
checked.

"dawson" wrote:

Hello,

I create and maintain a spreadsheet that many different people use
individual copies of across multiple terminal environments. In this
spreadsheets I have placed different command buttons. But for one of
terminal environments with Excel 2003 SP2 the command buttons will not
display. In the other 2 terminal environments (with excel 2000 sp3 and excel
2003 sp2) the buttons display fine. I can't seem to figure out why it won't
display in the first environment. All the buttons are enabled and have the
visibility set to true. I created the spreadsheet with excel 2000 sp3 if
that makes a difference somehow.

My question is :

Does anyone have any suggestions for things to check that might cause a
problem like I described above? or might I be overlooking something obvious?

Thanks in advance for any replies.


Dawson

Command button no displaying
 
Thanks for the suggestion. I took a look there and Show All is selected.

I tried toggling them back and forth to see if that would trigger the
buttons to show up on the screen, but it didn't help.

I will keep searching, but thanks again.

"JLGWhiz" wrote:

That should be ToolsOptionsView:Objects

"dawson" wrote:

Hello,

I create and maintain a spreadsheet that many different people use
individual copies of across multiple terminal environments. In this
spreadsheets I have placed different command buttons. But for one of
terminal environments with Excel 2003 SP2 the command buttons will not
display. In the other 2 terminal environments (with excel 2000 sp3 and excel
2003 sp2) the buttons display fine. I can't seem to figure out why it won't
display in the first environment. All the buttons are enabled and have the
visibility set to true. I created the spreadsheet with excel 2000 sp3 if
that makes a difference somehow.

My question is :

Does anyone have any suggestions for things to check that might cause a
problem like I described above? or might I be overlooking something obvious?

Thanks in advance for any replies.



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

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