Results 1 to 6 of 6

VBA Scroll Area

This is a discussion on VBA Scroll Area within the Excel Questions forums, part of the Question Forums category; Hi guys can you help here I ned to set the scroll area to the active cell ie lock the ...

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,166

    Default

    Hi guys can you help here

    I ned to set the scroll area to the active cell ie lock the sheet

    Also reset at the end to normal ie no scroll area setting

    Can this be done?/

    Cheers guys
    JITUK
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,702

    Default

    Howdy Jack, yes sir, see:

    http://www.mrexcel.com/board/viewtop...=18260&forum=2

    You can use auto procedures or events to make this happen. Happy holidays.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,166

    Default

    Hi Nate

    Im a bit behind here

    I have

    Sheets(5).ScrollArea = ActiveCell 'HardCoded

    Which is terrible but you see where i am setting the currect active cell to fix the scroll??


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    Board Regular
    Join Date
    Nov 2002
    Posts
    52

    Default

    THIS WORKED FOR ME

    Private Sub Workbook_Open()

    Worksheets("Title Page").Activate
    Sheet1.ScrollArea = "A1:R28"
    End Sub


  5. #5
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,702

    Default

    Howdy Jack, no errors and no functionality eh?

    Try the address property:

    Sheets(5).ScrollArea = ActiveCell.Address

    This is the typical requirement with property setting as such.

    Merry Christmas.

    _________________
    Cheers, Nate Oliver

    [ This Message was edited by: NateO on 2002-12-21 20:30 ]

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,166

    Default

    Hi Nate now close to 2am London

    Sleep now Ill use what i have and update this feel in a few hours - your be asleep then i guess.

    Take care buddy and a very big thanks for your help here

    JITUK


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

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
  •  


DMCA.com