I have a custom menu with a step that should open an input schedule.
Therefore I added a OPENWEBFILE action in the EV_DEFAULT sheet.
The path linked to this step should change according to a dimension of the current view.
-if DIMENSION=XX, the path should be INPUTSCHEDULES/XX/filename.xlt
-if DIMENSION=YY, the path should be INPUTSCHEDULES/YY/filename.xlt
I found a way to do it, but the formula is not refreshing when I change the current view, and the custom menu always open the same input schedule. The only way to refresh it is to go back to the EV_DEFAULT sheet and click on ETools, CustomMenuManager, Test Current Worksheet: this is something that a user is not allowed to do.
Do you have any idea about this? What could be a possible solution? Maybe a macro with an EV formula that refreshes the custom menu?
Thanks for your help