[mso] Re: Excel Scroll Bar
- From: Wilson Baptista Junior <wilson@xxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 16 May 2002 19:33:26 -0300
Hi Eric,
At 21:11 16/05/02 +0200, Eric Skeen wrote
>Thanks Linda, I have been doing that, but just wondered out of curiosity if
>there is a way of "re-setting" the vertical scroll bar.
>
>I simply hate it when the scroll bar indicates a massive file when the file
>is not that large.
>
>Curiosity killed the cat...
Try going to the last row which has data, then selecting down a lot of rows
(a few hundred) and deleting (not clearing) them (the whole rows).
Do the same with columns, from the last column you have data on forward.
Then save the file and try it out.
This should solve your problem. If it doesn't work, you can always do it
through a simple macro (put it in your workbook in the "This Workbook" area
in the VBA editor:
Private Sub Workbook_Open()
Worksheets("Your_Worksheet").ScrollArea = "A1:LastAddress"
End Sub
Where Your_Worksheet is the worksheet name and LastAddress is the address
of the last cell you want to be able to scroll to in the worksheet (for
example, BC990).
You can have as many such lines inside the sub as worksheets you want to
limit the scroll in. This is also useful when you want to limit an user
from scrolling to an area of the worksheet you don't want him to.
Only problem with the macro is that you have to edit it when you want to
use more rows or columns than you were using before.
Wilson
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx
or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with
a subject line that says "unsubscribe" (without the quotes). Do not put
unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps
prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
Other related posts:
