Spreadsheet.ApplyLayout

This function applies a spreadsheet layout to the spreadsheet.

Syntax Parameters Return Value 
Sub Spreadsheet.ApplyLayout( _
    LayoutName As String)
 LayoutName [in]

Which spreadsheet layout to apply.

Type: String

This function does not return a value.

SVB Example

Applying a layout to a spreadsheet: 

Option Base 1
Option Explicit
Sub Main
    Dim spr As Spreadsheet
    'assigns the active spreadsheet to the object spr
    Set spr = ActiveSpreadsheet
    'applies an Existing spreadsheet layout to the spreadsheet
    '(Layout must already exist)
    spr.ApplyLayout("Active Cell Header")
End Sub