Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scroll problem in Excel sheet
In one of worksheet, the sheet is protected. Locked cells can not be selected.
I have freezed the row and column both. At the extreme left and right columns of sheet are locked, therfore cant be selected. Sheet size is more than one screen. Now when I scroll from left to right thru arrow keys, the scroll restarts automatically from the first selectable column on screen-1, when it reaches at thelast selectable column on subsequent screens. How to stop the scroll when at the last selectable column? Can anybody plz help me? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scroll problem in Excel sheet
You could hide rows/columns so that the user can't even see them.
Or you could set the ScrollArea to be what you want--each time you open the workbook: Option Explicit Sub auto_open() With Worksheets("sheet1") .Protect Password:="hi" ' .EnableSelection = xlUnlockedCells .ScrollArea = .Range("a1:f22").Address End With End Sub Excel won't remember these settings after you close it and reopen the workbook (that's why it's in auto_open). If you want to keep the users from selecting locked cells, too, then uncomment that line in the middle. Ravi Garg wrote: In one of worksheet, the sheet is protected. Locked cells can not be selected. I have freezed the row and column both. At the extreme left and right columns of sheet are locked, therfore cant be selected. Sheet size is more than one screen. Now when I scroll from left to right thru arrow keys, the scroll restarts automatically from the first selectable column on screen-1, when it reaches at thelast selectable column on subsequent screens. How to stop the scroll when at the last selectable column? Can anybody plz help me? Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel won't scroll downwards on sheet with autofilter & freeze pan | Excel Discussion (Misc queries) | |||
Excel: Arrows scroll sheet instead of move cursor. How to switch | Excel Discussion (Misc queries) | |||
View, scroll and select a cell value from another Excel sheet? | Excel Worksheet Functions | |||
Excel sheet scroll bar options | Excel Worksheet Functions | |||
How do I create multiple scroll bars within one Excel sheet? | Excel Worksheet Functions |