VBA scroll restrictions not working on horizontal scroll...?

[Novelec]

Hi guys,

I am trying to lock the scroll areas in my work book. There are several sheets, each with a different area to be restricted.

I tried the sheet properties in the VBA window, only to find these values aren't carried over when the workbook is reopened. So I am trying my luck with some code. I've put the code listed below in "ThisWorkbook" module, so it operates upon the Workbook opening.

The code works restricting vertical scroll area, but horizontal scroll is still "unlimited"...? There are no errors, the horizontal scroll just keeps scrolling past where its supposed to stop. Can anyone shed some light on this one?

Everyone's help is always appreciated, I've been learning lots from this forum.

Worksheets("Worksheet 1 Name").ScrollArea = "$A$1:$U$54"
Worksheets("Worksheet 2 Name").ScrollArea = "$A$1:$U$465"
'etc...

I've also tried:

Worksheets("Worksheet 1 Name").ScrollArea = "A1:U54"
Worksheets("Worksheet 2 Name").ScrollArea = "A1:U465"
'etc...

 

[Andrew Poulsom]

With this code I cannot move beyond column U and below row 54 on Sheet1:

Sub Test()
    Worksheets("Sheet1").ScrollArea = "A1:U54"
End Sub

Are you experience different behaviour?

 

[Novelec]

Are you experience different behaviour?

Hi Andrew,

Thanks for the test. Using the code I am still able to scroll horizontally...? However I am starting to think my problem is hardware/software related...

The file containing this code was produced on a PC, running Excel 2010. The function works on this PC, locking both x and y axis scrolling.

However, when I use the same file on a Dell tablet computer (Also Excel 2010), I run into the scrolling issue.

Could this be an issue from outside Excel?

 

[Andrew Poulsom]

Sorry I have no idea why that should be happening.