Limit User scrolling

[Guest]

All,

On an auto_open() I want to limit users to not being able to scroll right as
there are data sets that I do not want them to have access to.

how can I lock it so that they can not scroll right/left off the viewable
screen, but still allowing them to go up and down?

TIA

Chris

 

[Markus Scheible]

Hi Chris,

how can I lock it so that they can not scroll right/left off the viewable
screen, but still allowing them to go up and down?

afaik excel only provides you with

Application.DisplayScrollBars = False

But: they can still navigate hy clicking a cell and using
the cursor...

why don't you just hide the columns containing data?
Format=>Column=>hide

Best

Markus

 

[NickHK]

Chris,
You can set the .ScrollArea of the WS, but as far as I know, it is not a
persistent property, so you have set it everytime the WB is opened.
The WS needs to be protected for this to have an effect.

NickHK

 

[Ajtb]

Hi Chris:

you can do something like this:

Sheets("SheetName").ScrollArea = "A1:Q90"


I have this line in a macro that runs every time the workbook opens.

This macro resides in the ThisWorkbook object:

Private Sub Workbook_Open()
Sheets("SheetName").ScrollArea = "A1:Q90"
End Sub


HTH

Andrew Bourke