Locking an Excel Spreadsheets Scrolling ability

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have attached a help page to my Excel Workbook. I
placed it in a spreadsheet so the user can use it as a
reference if they forget something. Now I protected the
sheet and was able to stop users from selecting any cells
but the can still scroll and move the form around and pay
not realize later that they just need to scroll back to
A1. So what I am asking is there a way that I can
completely lock a Sheet in excel. The only thing I want
it for is so they can view what I have writen. I used to
do this with Lotus 1-2-3 years ago.

Thanks,
Mark Manno
 
You can with an event macro:

Put this in the ThisWorkbook code module (Right-click on the
workbook's titlebar and choose View code):

Private Sub Workbook_Open()
With Sheets("MyHelp")
.ScrollArea = .UsedRange.Address
End With
End Sub

This setting doesn't persist from session to session, so you have to
use the Workbook_Open event.
 
You also can hide all rows and columns you don't people see (if your work is
in a1:d100 range, then hide all columns form E to IV an rows from 101 to
65536) and then protect you sheet. you'l see a gray area but you won't be
able to scroll beyond it.
I hope it works for you, too.
Mario
 
Back
Top