Dynamic custom menu

25 Views

Hi all,

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.

For instance,

-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