HELP! Command buttons moving to edge of Worksheet when unhiding rowsand-or columns

[RJQMAN]

I have a large workbook, and it has been working fine. It is written
in Excel 2003. I am now finding that once in a while, on some
computers, the command buttons jump to the top edge of the page and
sit on top of one another. I am aware of the problem in Excel 2002
that was supposedly fixed, but I am seeing it now when the program
written in Excel 2003 is run on Excel 2003 or Excel 2010. Not sure if
it happens when it is run on Excel 2007 or not. I am not certain of
this, but it seems to happen primarily on computers with less memory,
such as netbooks and older laptops. I just have not been able to
prove this to myself.

The buttons are in rows that are hidden until needed. The row (and
columns) are made visible, and the buttons are supposed to be there to
enable the user to move to choose options and/or to move to another
part of the program.

I am using 'zoom to fit' frequently on the sheet as well, so that the
section appears as large as practical to the user. I am partially
blind, so the 'zoom to fit' helps me a great deal. But I cannot have
the buttons moving out of the range area that is displayed, or it is
impossible for the program to function. Here is my question...

Would it resolve the problem if I removed the zoom to fit?
Could this problem be related to computer memory?
If it could be related to memory, is there some way that I can
determine how much memory is needed so that I can advise users of the
requirements of the program?

I really appreciate any help anyone can proved.

Many thanks...

 

[GS]

RJQMAN has brought this to us :

I have a large workbook, and it has been working fine. It is written
in Excel 2003. I am now finding that once in a while, on some
computers, the command buttons jump to the top edge of the page and
sit on top of one another. I am aware of the problem in Excel 2002
that was supposedly fixed, but I am seeing it now when the program
written in Excel 2003 is run on Excel 2003 or Excel 2010. Not sure if
it happens when it is run on Excel 2007 or not. I am not certain of
this, but it seems to happen primarily on computers with less memory,
such as netbooks and older laptops. I just have not been able to
prove this to myself.

The buttons are in rows that are hidden until needed. The row (and
columns) are made visible, and the buttons are supposed to be there to
enable the user to move to choose options and/or to move to another
part of the program.

I am using 'zoom to fit' frequently on the sheet as well, so that the
section appears as large as practical to the user. I am partially
blind, so the 'zoom to fit' helps me a great deal. But I cannot have
the buttons moving out of the range area that is displayed, or it is
impossible for the program to function. Here is my question...

Would it resolve the problem if I removed the zoom to fit?
Could this problem be related to computer memory?
If it could be related to memory, is there some way that I can
determine how much memory is needed so that I can advise users of the
requirements of the program?

I really appreciate any help anyone can proved.

Many thanks...

I believe this has to do with settings on the Format Control>Properties
tab!

Would it not be better to use a custom commandbar that's context
sensitive?

 

[Don Guillett]

I have a large workbook, and it has been working fine.  It is written
in Excel 2003.  I am now finding that once in a while, on some
computers, the command buttons jump to the top edge of the page and
sit on top of one another.  I am aware of the problem in Excel 2002
that was supposedly fixed, but I am seeing it now when the program
written in Excel 2003 is run on Excel 2003 or Excel 2010.  Not sure if
it happens when it is run on Excel 2007 or not.  I am not certain of
this, but it seems to happen primarily on computers with less memory,
such as netbooks and older laptops.  I just have not been able to
prove this to myself.

The buttons are in rows that are hidden until needed.  The row (and
columns) are made visible, and the buttons are supposed to be there to
enable the user to move to choose options and/or to move to another
part of the program.

I am using 'zoom to fit' frequently on the sheet as well, so that the
section appears as large as practical to the user.  I am partially
blind, so the 'zoom to fit' helps me a great deal.  But I cannot have
the buttons moving out of the range area that is displayed, or it is
impossible for the program to function.  Here is my question...

Would it resolve the problem if I removed the zoom to fit?
Could this problem be related to computer memory?
If it could be related to memory, is there some way that I can
determine how much memory is needed so that I can advise users of the
requirements of the program?

I really appreciate any help anyone can proved.

Many thanks...

with the command button or shape
format>properties>dont move or print

 

[GS]

Robert,
Is this the same project for FMBC? Regardless, just want to let you
know I'm plugging away at it between client work. I'll send you a
working sample as soon as I've got it to that point!

 

[RJQMAN]

Robert,
Is this the same project for FMBC? Regardless, just want to let you
know I'm plugging away at it between client work. I'll send you a
working sample as soon as I've got it to that point!

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Yes, Garry, it is the FMBC program. I am about 1/3 of the way through
the season here, and the program is working well except for this
unexpected problem. I appreciate your help. My vision is continuing
to get worse, and I have eye surgery tomorrow.. I have high hopes
that I will be able to better see the small print on the macros after
the surgery! We will see (pun intended).

 

[RJQMAN]

with the command button or shape
format>properties>dont move or print

I will try your solution. Thanks for responding.

 

[GS]

Yes, Garry, it is the FMBC program. I am about 1/3 of the way through
the season here, and the program is working well except for this
unexpected problem. I appreciate your help. My vision is continuing
to get worse, and I have eye surgery tomorrow.. I have high hopes
that I will be able to better see the small print on the macros after
the surgery! We will see (pun intended).

Best wishes tmo!

 

[RJQMAN]

with the command button or shape
format>properties>dont move or print

Hello Don;

What happens then is that the buttons are not hidden when the row is
hidden. I need to be able to hide some of the buttons (there are
about 50 of them) and only display a couple at a time. The program
hid the rows and/or the columns with the buttons, and this worked
beautifully - at least until the buttons started to move around the
sheet. At first I thought they were just not there, but I eventually
found them gathered at the top of the page and stacked on top of one
another.

The worksheet functions by displaying a few rows and a few buttons -
then depending on the button chosen, certain other rows display,
etc.

I think there is another way to trigger macros with a keystroke - I
will try to find some information on that today and put that option in
place in case the buttons take a hike around the perimeter on me.
Sigh. I do not know what else to do.

 

[GS]

FYI

Assuming you're referring to the Wizard on sheet 'ContestData' (I
renamed it to exclude spaces), I think a userform is the way to go here
and is what I'm working on. It will be structured like any form-based
wizard and much easier to manage and maintain. Ergo, the issue with the
page buttons will not exist as the project will use context-sensitive
customm toolbar and popup menus.

 

[RJQMAN]

FYI

Assuming you're referring to the Wizard on sheet 'ContestData' (I
renamed it to exclude spaces), I think a userform is the way to go here
and is what I'm working on. It will be structured like any form-based
wizard and much easier to manage and maintain. Ergo, the issue with the
page buttons will not exist as the project will use context-sensitive
customm toolbar and popup menus.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

OK. Sounds great, But I am 1/3 through the season and need to keep
the system working for 7 more weeks. Then I can rewrite for a year.
So I am trying to find a solution for the short term. E-mail me
directly if you wish to not clog up the group here. Thanks...

 

[Don Guillett]

Hello Don;

What happens then is that the buttons are not hidden when the row is
hidden.  I need to be able to hide some of the buttons (there are
about 50 of them) and only display a couple at a time.  The program
hid the rows and/or the columns with the buttons, and this worked
beautifully - at least until the buttons started to move around the
sheet.  At first I thought they were just not there, but I eventually
found them gathered at the top of the page and stacked on top of one
another.

The worksheet functions by displaying a few rows and a few buttons -
then depending on the button chosen, certain other rows display,
etc.

I think there is another way to trigger macros with a keystroke - I
will try to find some information on that today and put that option in
place in case the buttons take a hike around the perimeter on me.
Sigh.  I do not know what else to do.

Or, depending on what your buttons do you might be able to just get
rid of them and replace with a simple double click event tied to each
range using if or select case.