Thanks Alan,

You'll never guess that after all the posts i've written over the past
week the workbooks just gone n corrupted itself :( My IT department
says there's too much in but I even tried copy n pasting it into a new
one sheets by sheet to see how the file size grew n when i got to the
second one it shot from 17.5Kb to 11.1MB... damn putas :(

Doo
Alan wrote:
Oops! Forgot about that but if you still would like to go down this
route you just need the line

Worksheets("Sheet2").ScrollArea = "$A$1:$P$30"

in your workbook_open macro ... or you can hide the columns.


Don Guillett wrote:
You will have to do this each time you re-open so best to use a
workbook_open macro in the ThisWorkbook module to do it for you.

--
Don Guillett
SalesAid Software

"Doo0592" wrote in message
oups.com...
Ahhh, silly me! Never thought to look there! :)

Thanks Alan x


Alan wrote:

No sub required to restrict the scroll area ...

Go into the VBA editor but ensure that the Project and Properties
windows are visible. In the Project window click on and highlight the
sheet you want to restrict (e.g. Sheet1) and then scroll down to
"ScrollArea" in the Properties window. Click there and enter the range
you want to restrict to (e.g. A1:F6)

Good Luck!

Doo0592 wrote:
Ok, showing my nooby colours on this one!

I have tried them both n neither have worked.. where do I put them and
do they need a private sub?

Doo


Bob Phillips wrote:

Rows(n & ":" & Rows.Count).Hidden = True

where n is some starting number.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Doo0592" wrote in message
oups.com...
Hi all,

I have noticed that you can hide all the columns and rows that you
are
not using so the user cannot scroll past the relevant part of the
worksheet. I can hide all the column cause there aren't too many of
them when you scroll along but I tried this for the rows and it
seems
to just keep going on forever! lol Is there another way I can hide
ALL
the rows underneath so the end user can't scroll down?

Cheers :)