DialogSheetView Object (Excel)
Represents the current Dialog sheet view in a workbook.
To access this object, you must have a dialog sheet that was developed in the active workbook. Without the dialog sheet, the view properties for the object return an empty string value.
The following example turns on the dialog sheet view for the active workbook.
Worksheets("Sheet1").DialogSheetView.Visible = True