Restricting scrollig by arrows to certain area

[Dusan]

Hi there,

I've made an application containing some objets (buttons, combo boxes ...)
but also using excel cells.
Because only upper part of the sheet should be seen and used by users
I want to prevent any user bein able to scroll down or side ways to see
and possibly modify the cells.
I already disabled scroll bars but users still could sellect a cell
in allowed part and scroll by the down arrow.

Is there any way to define an area accesible by user to make my application
more bullet (or user?) proved?

Also if I disable scroll bars, user still can go to the options and activate
them. Is there any way to disable them for good?

Any thought appreciated,
Chhers
Dusan

 

[Don Guillett]

Set with a macro
activesheet.scrollarea="$a$1:$x$21"