Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Setting the limits of the worksheet

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Sheffield, UK
    Posts
    253
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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
    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Surrey, United Kingdom
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Sheffield, UK
    Posts
    253
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •