Solved

Another Excel question.

Posted on 1997-02-27
1
356 Views
Last Modified: 2010-04-25
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.
0
Comment
Question by:andrij
1 Comment
 
LVL 1

Accepted Solution

by:
dooly earned 100 total points
ID: 1539632
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article we will discuss some EI Capitan Mail app issues and provide some manual process to resolve them.
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question