Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Thursday, August 13, 2009 – Permalink –

Scroll Restrictions

Without Protection


You can protect a spreadsheet so that data is shielded from inadvertent entries.
There is another way to set up a scroll area that does not involve protection.
Open the Control Toolbox (right-click any existing tool bar) and click on the Properties icon.

In the Scroll Area text box, type the scroll area range, or type the defined Name for the range.
To cancel the Scroll Area restricted range, clear the Scroll Area text box.



If you are using Office 2007, the Property icon is on the Developers tab.



Multiple areas can be selected using Protection, but only one area is allowed using the Scroll Property.



[Edited entry from 7/10/2006]




See all Topics

Labels:


<Doug Klippert@ 3:28 AM

Comments: Post a Comment

Links to this post:

Create a Link