View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter Atherton[_8_] Peter Atherton[_8_] is offline
external usenet poster
 
Posts: 1
Default Restricting cells

Noctos

You can unlock the cell the user is to have access to and
protect the worksheet. The user can then tab between the
unprotected cells. The can still use the Arrow keys are
whatever to scroll down the sheet.

You might want to place sensitive data on another sheet
and hide it.

I don't know about hiding scroll bars - maybe the experts
do.

Regards
Peter

-----Original Message-----
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/

.