Scroll Lock

**kteig** · 07-18-2008, 09:53 AM

I want to have my protected excel sheet so the user can only view A to AF, but I do not want to hide the other cells. A to AF requires the horizontal scroll so I can not simply lock the screen.

Any suggestions? Any help is appreciated.

**StephenR** · 07-18-2008, 11:21 AM

Perhaps by setting the sheet's scroll area in the VBeditor?

**manny_cb** · 07-18-2008, 11:44 AM

not sure wat you exactly mean by u cud do this... select colum A to AF

Go Format > Cells > Protection .. take off locked click ok
now go Tools > Protection > Protect Sheet
Check off select locked cells
click ok

that helps ?

**kteig** · 07-18-2008, 01:53 PM

Originally Posted by StephenR

Perhaps by setting the sheet's scroll area in the VBeditor?

How would I do that?

**VBA Noob** · 07-18-2008, 02:19 PM

Press Alt + F11 > select the sheet name you want to control the Scroll (See link) > then on the properties tab look for Scroll Area. Note if the properties window isn't displayed you can locate it under the view menu. Then enter a range in the scroll Area

E.g $A$1:$H$50

http://www.contextures.com/xlvba01.html#Workbook

Or see link
http://www.ozgrid.com/Excel/limit-scrolling.htm

or with code. Right click sheet tab > select view code > paste in the below

Please Login or Register  to view this content.

HTH

VBA Noob

Scroll Lock

LinkBack

Thread Tools

Rate This Thread

Display

Scroll Lock

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions