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

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


TIA

Chris

.

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

"Chris" wrote in message
...
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

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

Chris wrote:
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