Restrict Movment on a sheet

[Te4t0n]

Hi, I would likw to know if you can restrict movment on sheets in excel, i mean by this like restrict horizontial and vertical bar movment ? if so how would i go about it i have looked or hours in the help files and on the internet.. but i find nothing so far.

 

[KenWright]

Perhaps you could clarify your request somewhat and give us some examples of what would and wouldn't be acceptable.

Can they scroll at all - if so how far etc

 

[Te4t0n]

The scroll bars are hidden and i dont want them to move up or down, left or right at all, i set the screen to display all i want them to see. problem is the middle mouse wheel can scroll up and down, the most right cell and most bottom row u can see on the screen is column r and row 44, i wish them not to go past these.

 

[nicolavision]

Hi

If your using Excel 2003 you could set the Permissions property to only allow the user to select unlocked cells.

I'd allows hide all othe columns and rows so that even if they scroll with the mouse button they don't actually go anywhere. It will just show grey space.

HTH

 

[Te4t0n]

isn't there any like on scroll events or workbook event for change ? so i know if the scroll right-left or up-down is changing ?

 

[nicolavision]

You could try

Worksheets("Sheet1").Activate
ActiveWindow.LargeScroll down:=3

And set the = 0

Not tested but...

 

[KenWright]

In the ThisWorkbook module

Private Sub Workbook_Open()
Sheet1.ScrollArea = "$A$1:$R$44"
End Sub

Note that they will have the option of enabling/disabling macros at the start which will enable/disable this option unless you cater for that some other way.

Obviously change the sheet name for the right one

 

[Te4t0n]

thanks, yep i no about enableing macros at the start and stuff bt thankyou alot.