Solved

Another Excel question.

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Package creation on OS X uses the PackageMaker utility installed as part of the XCode development suite ( on the OSX Client CD).  Packages can be installed as part of the machine build process, or later using Apple Remote Desktop. They are generally…
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 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…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

735 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