Skip to Content
0
Former Member
May 22, 2009 at 10:08 PM

Save the active session CV with this workbook not working!

20 Views

Dear all:

Situation

For our budgeting purpose, I have created an input schedule that allows expansion, and I need to default the Current View to certain settings while not "locking" it. To prevent the users from accidentally expanding the input schedule with their CV, I wish to save a specific CV for this input schedule. For instance, I want my Account Dimension to be "Balance_Sheet" rather than their CV, especially when the CV is easy to change when toggling back and forth different reports and input templates.

Data

I have checked "Save the active session CV with this workbook", under eTools --> Workbook Options. However, after I saved and reopened the input schedule, it didn't show the CV that I saved.

Question

Is there any bug with the "Save the active session CV with this workbook"? Or I am having the wrong idea about this option?

In addition, is there a way to use Macro to set CV in Workbook_Open() function?

Thank you! Happy Memorial Weekend!

Brian