Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Another Excel question.

Posted on 1997-02-27
1
Medium Priority
?
361 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
dooly earned 200 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

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…
Are you looking to clear some space on your phone for the latest iOS 8 update? Did you switch to Spotify so you no longer need to keep music native on your phone? Run out of space for taking photos while in the middle of vacation? Sometimes the quic…
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

688 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