How to disable scrolling

T

The Soft

I like to make a excelsheet that is partialy accessable.
Only the rows and colomns on the user display (depending on the monitor
resolution) might be accesseble.

So... I like to disable the scroll function. I can already disable scroll
bars, but is it possible to disable the scrollwheel in excel?

The Soft
 
S

serdar

this may work for a worksheet (reset "a1:n20" as you like):

Private Sub Worksheet_Activate()
Application.DisplayScrollBars = False
Worksheets("name of worksheet").ScrollArea = "A1:N20"
End Sub
 
Top