RestoreSheetSelection Method

Restores saved row and column information of a selected sheet view.

Syntax

expression.RestoreSheetSelection

*expression   *     Required. An expression that returns an Application object.

Example

The following example demonstrates how SaveSheetSelection and RestoreSheetSelection work.

Sub SelectionDemo()

    '1) In your sheet view, make column/row/cell selections, then run this 
    '2) macro which toggles the Project Guide display state, and 
    '   clears the ActiveSelection (saved via Application.SaveSheetSelection).
    '3) The macro then restores the ActiveSelection via Application.RestoreSheetSelection
    
    'Save the ActiveSelection in the active sheet view
    Application.SaveSheetSelection
        
    'Toggle the Project Guide display state
    Dim boolPGON As Boolean
    boolPGON = Application.DisplayProjectGuide
        
    If boolPGON = True Then
        Application.DisplayProjectGuide = False
    Else
        Application.DisplayProjectGuide = True
    End If
    
    MsgBox "The Project Guide display state has been toggled. " _
        & "Notice that your active selection was cleared in the " _
        & "process." & Chr(10) & Chr(10) _
        & "Now the call to RestoreSheetSelection restores the ActiveSelection...", _
        vbOKOnly
        
    Application.RestoreSheetSelection
    
End Sub

Applies to | Application Object