Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding area codes only to phone numbers missing an area code | Excel Discussion (Misc queries) | |||
arrows dont move objects inside graph (plot) area | Excel Discussion (Misc queries) | |||
Restricting Scroll Area | Excel Discussion (Misc queries) | |||
restricting use of certain characters | Excel Discussion (Misc queries) | |||
Restricting Menus | Excel Programming |