Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Limiting Access to a Range (Excel 2000)

    I am needing to limit a user's movment on a sheet to a specific range. I used to have the code for this but can't find it...
    I only want them to access range b5:e10 and not be able to move outside of that range.

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limiting Access to a Range (Excel 2000)

    Hi Bill,

    I think you are looking for something like

    Activesheet.ScrollArea="a1:n40"

    This prevents the user from selecting a cell outside of this area.

  3. #3
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limiting Access to a Range (Excel 2000)

    just a quick note here: ScrollArea needs to be reset each time you open the workbook.

    HTH

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limiting Access to a Range (Excel 2000)

    As an alternative to setting a scrollarea you could hide column A and F:IV and rows 1:5 and 11:65536
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Star Lounger
    Join Date
    Feb 2001
    Location
    Springdale, Arkansas
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limiting Access to a Range (Excel 2000)

    This is Exactly what I was needing. Thank you! I've set the macro to open when the workbook opens.

Posting Permissions

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