How to disable scrolling

  • Thread starter Thread starter The Soft
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic stacked bar chart scroll bar 1
Guus 1
logitech mouse wheel in Excel zooming rather than scrolling 1
Vertical Scroll issue with Excel 2013 1
Disable new grid Chrome tabs on Android 9
smooth scrolling lag 3
Scrolling Very Slow 2
Disable scrollwheel in ComboBox? 2

Back
Top