 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / August 2007Scroll Area
Hi, Using xl 2004 version 11.3.5 Problem is after setting Scroll Area to my database size can no longer select columns or rows or edit outside the scroll area. Is this normal. Have a rather large database and was tired of scrolling into empty space. Any way around this bar deleting scroll area settings. Thanks Paul Hi Paul - I don't think I have an answer for you as I have no idea what you mean by "setting Scroll Area". In ~20 years I've seen no such feature in any version of Excel, PC or Mac. Can you be more specific about what you've done & how you went about it? Is this something you've done programmatically? I'd appreciate any insights on the issue :) Regards |:>) Bob Jones [MVP] Office:Mac On 8/29/07 9:31 PM, in article C2FC5B08.11AB%asking@optusnet.com.au, "Skin Paul" <asking@optusnet.com.au> wrote: > Hi, Using xl 2004 version 11.3.5 > Problem is after setting Scroll Area to my database size can no longer > select columns or rows or edit outside the scroll area. Is this normal. Have > a rather large database and was tired of scrolling into empty space. > Any way around this bar deleting scroll area settings. > Thanks Paul > I don't think I have an answer for you as I have no idea what you mean by > "setting Scroll Area" Number of visible rows/columns?  SignatureRIGHT Remove spam to email http://righttax.org > I'd appreciate any insights on the issue Look at the ScrollArea Property in XL/VBA Help. This is a very common setting for XL applications, often backed up by the Workbook_SelectionChange event if the app leaves the Name box accessible. On 8/29/07 9:31 PM, in article C2FC5B08.11AB%asking@optusnet.com.au, "Skin Paul" <asking@optusnet.com.au> wrote: > Hi, Using xl 2004 version 11.3.5 > Problem is after setting Scroll Area to my database size can no longer > select columns or rows or edit outside the scroll area. Is this normal. Have > a rather large database and was tired of scrolling into empty space. > Any way around this bar deleting scroll area settings. > Thanks Paul If you are doing this with the list manager, that is what it is for. You'll have to turn it off to select something outside the list area, if the list area is larger than your screen sixe. Try zooming and then select another cell. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom Hi again, When you open in VBA mode, in the projects windows double click on the sheet you are using then in the properties window 3rd line from the bottom is the scroll area if you set this, it limits how far you can scroll. I should have been more specific. Thanks On 30/8/07 11:44 PM, in article C2FC41E6.9C621%bob@nospam.com, "Bob Greenblatt" <bob@nospam.com> wrote: > On 8/29/07 9:31 PM, in article C2FC5B08.11AB%asking@optusnet.com.au, "Skin > Paul" <asking@optusnet.com.au> wrote: [quoted text clipped - 10 lines] > area is larger than your screen sixe. Try zooming and then select another > cell. On 8/30/07 10:27 AM, in article C2FD10D4.11C7%asking@optusnet.com.au, "Skin Paul" <asking@optusnet.com.au> wrote: > Hi again, When you open in VBA mode, in the projects windows double click on > the sheet you are using then in the properties window [quoted text clipped - 19 lines] >> area is larger than your screen sixe. Try zooming and then select another >> cell. Yes, in this case this is completely normal. That is what setting this is for. No, the only way around is to delete or change the scroll area settings. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom Thanks again for the reply Bob. I am on a steep learning curve and the replies and posts from all are terrific. Paul On 31/8/07 1:03 AM, in article C2FC5471.9C63A%bob@nospam.com, "Bob Greenblatt" <bob@nospam.com> wrote: > On 8/30/07 10:27 AM, in article C2FD10D4.11C7%asking@optusnet.com.au, "Skin > Paul" <asking@optusnet.com.au> wrote: [quoted text clipped - 27 lines] > for. No, the only way around is to delete or change the scroll area > settings. Wellll, Yeah.... that makes a bit of a difference:-) As Bob G has explained you basically got what you asked for, but the range can be adjusted as necessary. Unless you have a specific need to use that capability you might try leaving it unchanged and just drag the Scroll Bar button. It automatically sets itself to the extent of the used area on the sheet, but you can still use the Scroll Arrows to go beyond if need be & it doesn't take the peripheral cells out of action. If you aren't familiar with them you might also want to take a look in Excel Help for other navigation techniques. SignatureHTH |:>) Bob Jones [MVP] Office:Mac > Hi again, When you open in VBA mode, in the projects windows double click > on [quoted text clipped - 24 lines] >> area is larger than your screen sixe. Try zooming and then select another >> cell. > Hi, Using xl 2004 version 11.3.5 > Problem is after setting Scroll Area to my database size can no longer > select columns or rows or edit outside the scroll area. Is this normal. Have > a rather large database and was tired of scrolling into empty space. > Any way around this bar deleting scroll area settings. > Thanks Paul If you've set the Scroll area via VBA, you can still select cells outside that area using the Name box on the Formula toolbar. For instance, if your scroll area is A:D, you can enter G7 in the Name box and make an entry. You can also type in a range, say, G5:G10, and you can make entries and use the Return and Tab keys to navigate. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.