cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic custom menu

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Please enable the custom menu in BPC administration console and use the Open Custom Menu option in BPC for Excel to open the appropriate custom menu. Please check here whether the custom menu is refreshed or not. Test Current Worksheet is supposed to simulate this and test the custom menu before enabling it in the BPC administration consol.

Custom menus already have macro functions included in it. Please try to utilise those macros when necessary, instead of building new ones.

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks a lot: that's what I did and it works now