locking the scroll?

G

Guest

Hello,

I the portion of a worksheet that I currently have positioned so that it is
the only visible part of the sheet. But the scroll bar and the wheel on the
mouse can be used to move the sheet. What can I do to lock any scrolling?

Thank You
Brian
 
J

Jason Morin

Run a macro using:

ThisWorkbook.ActiveSheet.ScrollArea = "A1:J30"

HTH
Jason
Atlanta, GA
 
G

Gord Dibben

Brian

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:J30"
End Sub

Gord Dibben Excel MVP
 
C

Cgbilliar

Since no one has replied to your problem and I know very little myself you can
try to click on a cell at the bottom right corner of your sheet then click on
Windows, Freeze panes this may help.
 

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

Excel Unable to use mouse for scrolling 5
Vertical Scroll issue with Excel 2013 1
Auto-scrolling multiple sheets 2
Mouse scroll failure when looking at code 4
How do I stop a worksheet from scrolling? 4
scroll lock 9
Is there a way to restrict the view of a worksheet 1
How do I make the scroll wheel not work on a worksheet? 1

Top