| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
block scrolling
Hi all
Is is possible to "freeze" an excel sheet in such a way that the user can only scroll around in a certain delimited area? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
block scrolling
You could have a macro that does some fancy protecting--put it in your auto_open
or workbook_open event: Option Explicit Sub auto_open() With Worksheets("sheet1") .Protect Password:="hi" .EnableSelection = xlUnlockedCells .ScrollArea = .Range("c9:d122").Address(external:=True) 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). Claude wrote: Hi all Is is possible to "freeze" an excel sheet in such a way that the user can only scroll around in a certain delimited area? Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| End if without Block If | Excel Worksheet Functions | |||
| Excel- smooth scrolling (instead of 'snap' scrolling) | Setting up and Configuration of Excel | |||
| Vertical scrolling...jumps rather than smooth scrolling | Excel Discussion (Misc queries) | |||
| Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
| Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
