• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 844
  • Last Modified:

Unrestrict restricted scroll area

Dear Experts:

below macro restricts the user to a specific area of a worksheet.

I inserted this sub into the sheet module of the sheet on which I would like to limit the scroll area.

I wonder which code undoes this, i.e. the scroll area is to be 'unrectricted' for the active worksheet.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

Private Sub Worksheet_Activate()
RestrictUser Range("A1:EO44")
End Sub

Sub RestrictUser(WhichRange As Range)

With WhichRange.Worksheet
.ScrollArea = WhichRange.Areas(1).Address
End With
End Sub

Open in new window

Andreas Hermle
Andreas Hermle
1 Solution
Rory ArchibaldCommented:
Private Sub Worksheet_Activate()
Me.Scrollarea = ""
End Sub

Open in new window

would do it.
Andreas HermleTeam leaderAuthor Commented:
Hi rorya:

ok, thank you very much for your quick and professional help.

Regards, Andreas
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now