Worksheet.ScrollArea Property (2007 System)
Gets or sets the range where scrolling is allowed, as an A1-style range reference.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public Property ScrollArea As String
'Usage
Dim instance As Worksheet
Dim value As String
value = instance.ScrollArea
instance.ScrollArea = value
[BrowsableAttribute(false)]
public string ScrollArea { get; set; }
[BrowsableAttribute(false)]
public:
property String^ ScrollArea {
String^ get ();
void set (String^ value);
}
public function get ScrollArea () : String
public function set ScrollArea (value : String)
Property Value
Type: System.String
The range where scrolling is allowed, as an A1-style range reference.
Remarks
Cells outside the scroll area cannot be selected.
Set this property to an empty string ("") to enable cell selection for the entire sheet.
Examples
The following code example uses the ScrollArea property to set the scroll area of the current worksheet to the range of cells from A1 to Z100.
This example is for a document-level customization.
Private Sub SetScrollArea()
Me.Range("A1", "Z100").Value2 = "X"
Me.ScrollArea = "A1:Z100"
End Sub
private void SetScrollArea()
{
this.Range["A1", "Z100"].Value2 = "X";
this.ScrollArea = "A1:Z100";
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.