Hi,
I have a basic input schedule with several tabs, but the "main" tab requires users to click a button to select the desired member from the dimension. I'd like to utilize the entity they select from this tab, and pass it through to an "autorefresh" on the other tabs. I've got the Worksheet Activate code working on tab / sheet selections, including running either ExpandActiveSheet and RefreshActiveSheet, but I'd like it to inherit the member selected on the main tab. Right now, the sheet does refresh or expand based on which one I use, yet the data isn't correctly pulling up with the values I know are in the system.
Is there code I can use to either pull from the ContextMember Selected via the button mentioned above and pass it as a variable into my worksheet activate code? or a simpler idea?
Thanks!