Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhiding rowsand-or columns
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhiding rows and-or columns
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 ControlProperties tab! Would it not be better to use a custom commandbar that's context sensitive? -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhidingrows and-or columns
On Oct 5, 11:06*am, RJQMAN wrote:
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 formatpropertiesdont move or print |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhiding rows and-or columns
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 at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhidingrows and-or columns
On Oct 5, 2:11*pm, GS wrote:
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). |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhidingrows and-or columns
On Oct 5, 1:22*pm, Don Guillett wrote:
On Oct 5, 11:06*am, RJQMAN wrote: 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 formatpropertiesdont move or print I will try your solution. Thanks for responding. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhiding rows and-or columns
on 10/5/2011, RJQMAN supposed :
On Oct 5, 2:11*pm, GS wrote: 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). Best wishes tmo! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhidingrows and-or columns
On Oct 5, 1:22*pm, Don Guillett wrote:
On Oct 5, 11:06*am, RJQMAN wrote: 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 formatpropertiesdont 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. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhiding rows and-or columns
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 at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhidingrows and-or columns
On Oct 5, 7:25*pm, GS wrote:
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... |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Command buttons moving to edge of Worksheet when unhidingrows and-or columns
On Oct 5, 6:06*pm, RJQMAN wrote:
On Oct 5, 1:22*pm, Don Guillett wrote: On Oct 5, 11:06*am, RJQMAN wrote: 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 formatpropertiesdont 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. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding/unhiding rows & columns with "+" and "-" buttons | Excel Discussion (Misc queries) | |||
Command buttons moving in Excel | Excel Programming | |||
Excel VBA moving embedded command buttons | Excel Programming | |||
Excel VBA moving embedded command buttons | Excel Programming | |||
Command Buttons on Sheet moving with cells | Excel Programming |