+ Reply to Thread
Results 1 to 3 of 3

Limiting scroll area

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-12-2006
    Location
    Portugal
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    212

    Limiting scroll area

    Hello to everyone.

    For Excel 2003.
    I have a workbook that i need to give to other users. In some worksheets i need to limit the area users can access so i right click on the worksheet tab, select View Code and enter the area users can use on the Scroll Area property. It works when i'm using the workbook. However, when users open the workbook, this definition is no longer active and they can access all the worksheet. Am i doing something wrong?

    Thanks to all in advance.

    Octavio

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: Limiting scroll area

    No - that property is not saved with the workbook. You'll need to use the Workbook_Open event to reset it for each sheet when the workbook is opened.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Contributor
    Join Date
    06-12-2006
    Location
    Portugal
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    212

    Re: Limiting scroll area

    Thanks a lot R

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1