Solved

Another Excel question.

Posted on 1997-02-27
1
351 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Hi Folks, This article is intended to throw some light or basically give an idea towards taking the first step in the world of Systems Administration. This would in the real context of the word "Systems Administration" which would mean right from…
Steve Jobs once said that Blu-ray is "a bag of hurt". As Macs users well known, things haven’t settled down (at least not from Apple’s perspective). Several years after that comment, Mac OS X still doesn’t support Blu-ray playback, nor has any Mac s…
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…

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now