Office 365 (or other) Anomoly: Scroll Wheel overriding 'activesheet.scrollarea

[jamesart]

Hi Guys,

We have a workbook whose sheets we have restricted areas users can easily access via setting the scroll area, via activesheet.scrollarea=A:Z

An interesting situation arose where a user just reported that they were able to scroll down much further than they should and see sensitive data.

This only occurs on a couple of computers running Windows 10 and Office365.
All using exact same program.

It does not exhibit this behaviour on my home computer.

It does exhibit this behaviour on my work (server) computer.

Initially thought it was because of an Office version update, so I created a new login on my work computer to test.


It did NOT scroll the page beyond the set scroll area, as intended, on this login.

Same computer. Same version of Windows and Office. 2 different logins.
1 behaves as it should and does not scroll the page on scrolling mouse wheel.
1 misbehaves and scrolls the page on scrolling mouse wheel.

Has anyone ever encountered this kind of behaviour, or have any ideas of where to begin looking?

I should mention that I did a side by side comparison of all settings in options, and changed all available settings to match the one that behaved as it should, and it still misbehaved.

If not Office, could it be a windows setting? Or profile?

I am stumped so if anyone has an idea I would really appreciate hearing your thoughts.

Thank you,
James

 

[jamesart]

And, just to be clear, I do not actually use activesheet.scrollarea=A:Z but activesheet.scrollarea="A1:Z44", for example.

 

[jamesart]

Hi Guys,

We have a workbook whose sheets we have restricted areas users can easily access via setting the scroll area, via activesheet.scrollarea=A:Z

An interesting situation arose where a user just reported that they were able to scroll down much further than they should and see sensitive data.

This only occurs on a couple of computers running Windows 10 and Office365.
All using exact same program.

It does not exhibit this behaviour on my home computer.

It does exhibit this behaviour on my work (server) computer.

Initially thought it was because of an Office version update, so I created a new login on my work computer to test.


It did NOT scroll the page beyond the set scroll area, as intended, on this login.

Same computer. Same version of Windows and Office. 2 different logins.
1 behaves as it should and does not scroll the page on scrolling mouse wheel.
1 misbehaves and scrolls the page on scrolling mouse wheel.

Has anyone ever encountered this kind of behaviour, or have any ideas of where to begin looking?

I should mention that I did a side by side comparison of all settings in options, and changed all available settings to match the one that behaved as it should, and it still misbehaved.

If not Office, could it be a windows setting? Or profile?

I am stumped so if anyone has an idea I would really appreciate hearing your thoughts.

Thank you,
James

Activesheet.scrollarea is firing and DOES stop your scrolling when using the scroll bars, but is overridden by the mouse wheel.