Stop users from scrolling about in Excel:-
Here's a very simple line of code that will stop users from scrolling about a chosen worksheet. To place the code in, right click on the sheet name tab, select "View Code" and paste in this code.
Private Sub Worksheet_Activate()
Me.ScrollArea = "A1:T50"
'To set back to normal use:
Me.ScrollArea = ""
End Sub
Here's a very simple line of code that will stop users from scrolling about a chosen worksheet. To place the code in, right click on the sheet name tab, select "View Code" and paste in this code.
Private Sub Worksheet_Activate()
Me.ScrollArea = "A1:T50"
'To set back to normal use:
Me.ScrollArea = ""
End Sub
No comments:
Post a Comment