Restricting scrollig by arrows to certain area
 

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

Restricting scrollig by arrows to certain area
 

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

--
Don Guillett
SalesAid Software

"Dusan" <a@a wrote in message
...
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