Setting the limits of the worksheet

[philR]

This is doing my nut. Is there any way to set the size of the worksheet? For example, if I only want 8 rows and 8 columns, can I set a worksheet up like that? I don't mean hiding the rest, I mean getting rid of them completely. I am sure I have seen this done, but I can't find it and it is doing my head in.

Thanks

[Ivan F Moala]

On 2002-05-03 01:44, philR wrote:
This is doing my nut. Is there any way to set the size of the worksheet? For example, if I only want 8 rows and 8 columns, can I set a worksheet up like that? I don't mean hiding the rest, I mean getting rid of them completely. I am sure I have seen this done, but I can't find it and it is doing my head in.

Thanks

Hi Phil AFAIK you can't just get rid of the
rows and columns...you will have to hide them

[Nibbles]

Hi,

A post on the 26th April was similar to this. Sorry, don't know how to post a link to it, but Ian Mac suggested the following solution:

"If your using XL97 this won't work.

If you right-click on the worksheet tab and select view code, in the properties of the Visual Basic Editor for that sheet there is a blank field called Scroll Area.

I say it does work for XL97 because you can select a area and I'll seem fine but save and close, the next time It'll be back to normal.

Having said that I just tried using

Private Sub Workbook_Open()

Sheet1.ScrollArea = "A1:M10"

End Sub

and that'll do it for you. change the range to suit.


_________________
Share the wealth!!
Ian Mac"

Hope this helps,

Nibbs

[philR]

Thanks guys! I must've been mistaken, but thanks for reminding me about the scroll area thing, I was going to ask about that as well.