Noctos,

Yes you can...

First of all Rightclick on cells a2 and b3, choose Format Cells. Goto the
Protection tab and unselect the option Locked.

Now, to make sure the user cannot scroll off the page, you should hide all
the rows and columns that the user is not
supposed to see (no matter if they are used or not). You can do that by
clicking on the rowlabel of the top row, push the buttons [End] [Arrow
down], rightclick on one of the selected rowlabels and choose the option
Hide. After this click on the columnlabel of the most left row you want to
hide, push the buttons [End] [Arrow right], rightclick on one of the
selected columnlabels and choose the option Hide.

Now Protect your worksheet by selecting Tools / Protection / Protect
Sheet... (you can sepecify a password if you want, not obligated). Now your
worksheet should work as intended.

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl

"Noctos " schreef in bericht
...
is it possible to preventing a user select any cells on the workbook
apart from a2 and b3 and preventing them from scrolling down the page.
And maybe if it is possible for the use to get from cell to cell by
just pressing tab like we do on the net. thanks if you can solve this
problem.


---
Message posted from http://www.ExcelForum.com/