Page.cp
The page.cp object has properties and methods related to the Control Pane in the workbook or matrixbook window. The page object can be referred to using "page".
Properties
| Property | Access | Description |
|---|---|---|
| page.cp.show | Read/write numeric |
Show or hide the Control Pane: 1 = show, 0 = hide. |
| page.cp.type$ | Read Only | Returns the Control Pane type |
Methods
| Method | Description |
|---|---|
| page.cp.add(postion percent name [option]) | Add Control Pane postion: 1 = left, 2 = top,3 = right, 4 = bottom |
| page.cp.remove() | Remove the Control Pane. |
| page.cp.settree() | Set GETN tree to the Control Pane. |
| page.cp.DATAFILTER | Open/Collapse the control panel of worksheet data slicer. |
| page.cp.BOOKSHEETCHANGER | Open/Collapse the control panel of workbook/worksheet graph browser. |
| page.cp.SHAREDDATAFILTER | Open/Collapse the control panel of graph slicer. |
| page.cp.COLUMNSWITCHINGBROWSER= | Open/Collapse the control panel of column grph browser. |
Examples
page.cp.add(1 25 DataNavigator:DC 3)
Add Sheet/Book Switching Browser Graph
page.cp.add(1 24 PlotsBookSheetChanger)