LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default 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...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hiding/unhiding rows & columns with "+" and "-" buttons shellshock Excel Discussion (Misc queries) 2 August 3rd 05 05:22 AM
Command buttons moving in Excel Tharkaway Excel Programming 3 March 14th 05 08:03 PM
Excel VBA moving embedded command buttons jgcuk Excel Programming 0 June 29th 04 05:41 PM
Excel VBA moving embedded command buttons jgcuk[_2_] Excel Programming 0 June 29th 04 05:34 PM
Command Buttons on Sheet moving with cells Todd Huttenstine[_2_] Excel Programming 4 November 30th 03 09:23 PM


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"