VBA Workbook Options 
You can use several Visual Basic for Applications (VBA) variables in the Microsoft Excel Name object to define workbook options.
Prerequisites
To apply these variables to the workbook, you should be familiar with VBA programming.
Features
The following table shows the available variables:
Variable |
Description |
Example values |
|---|---|---|
EV__EXPOPTIONS__ |
The drill down options control the member expansion behavior in the active spreadsheet. 0: (Expand by Overwriting Rows) - The expanded members display in the rows below the expanded member, clearing existing members as needed. 1: (Expand by Inserting Rows) - Any rows below the expanded member shift down, and new rows are inserted to accommodate the newly-displayed members. |
1 |
EV__LASTREFTIME__ |
Displays the time of the last refresh (EVRTI function) |
2008–07–15 10:38:24 |
EV__LOCKEDCVW__(appname) |
Locks the current view in the specified application. |
|
EV__LOCKSTATUS__ |
Specifies the Park N Go status. 1: Live data and static current view 2: Static data and static current view 4: Offline workbook |
1 |
EV__MAXEXPCOLS__ |
Specifies the maximum number of columns for expansion. |
100 |
EV__MAXEXPROWS__ |
Specifies the maximum number of rows for expansion. |
1000 |
EV__MEMORYCVW__ |
Specifies whether or not the system memorizes the current view in the workbook. 0: Do not memorize 1: Memorize |
1 |
EV__WBEVMODE__ |
Specifies the workbook mode: 0: Report 1: Input schedule |
1 |
EV__WBREFOPTIONS__ |
Specifies refresh and expand options: 1: Recalculate workbook on worksheet update 2: Recalculate workbook on worksheet open 4: Recalculate on CurrentView change 8: Refresh after data send 16: Expand on workbook open 32: Expand on CurrentView change 134217728: Allow users to change options |
41 |
EV__WBVERSION_ |
An internal flag. |
0 |