Another Excel question.

Hello.

      I have another Excel 5.0 question. How do I prevent a person using my worksheet from scrolling up or down (or left and right). I know that I can remove the scroll bars and what ever, and trap the page down key, but if you use the arrow keys you can still accidentally move vertically or horizontally. Is there any way you can do this? Thanks in advance.
andrijAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
doolyConnect With a Mentor Commented:
Tools Menu | Options | View Tab, then uncheck the vertical and horizontal scrollbar check boxes.

That will keep you from scrolling, unless you can convice them to set their view options the same way.

If you're trying to prevent them from view data, place the data on another sheet in the workbook (you'll have to redo some of the formulas on the sheet in which the data is summarized or manipulated), then save only the sheet you want them to see with "Save As" and select "Microsoft Excel 4.0 Worksheet" as the file type.

I'll call that an answer too...
0
All Courses

From novice to tech pro — start learning today.