MNU command to open custom menu ?

[Former Member]

Hello,

I did not see any mnu command or EV_function to open a custom menu, it is possible to do this ? or at list open the action in the action pane ...

I just tested the enhancement of SP06 to let change the home page of BPC? it is working find and I can put an input template directly. But the action pane is opened on a state without the link "open custom menu".

I need to click on "Home" again on top and then click Open Custom menu.

I would like if possible to put a custom button in my report to let the user open a custom menu if he needs more actions.

You will tell me that I can create my own menus without the custom menu, which is right ... but I cannot create one file that will be populated differently according to the rights of the user ... right ?

Thank you very much in advance.

Maybe John ? 🙂 I tried to make a search in notes in the case it would be added ... but I could not find this ...

[former_member186498]

Hi Eric,

if you insert this in Worbook_open event of an xls, it will start BPC (first line)

open the custommenu you choose (second line)

and close without message the worksheet with the code (third line)

so you can create several files with different custom menus.

Private Sub Workbook_Open()
Application.Workbooks.Open ("C:\Programmi\SAP BusinessObjects\PC_MS\Ev4Excel.xla")

Application.Workbooks.Open ("\\<FullDomainServerName>\osoft\Webfolders\<appset>\<application>\EEXCEL\REPORTS\WIZARD\PROCESSMENU\<...")

ThisWorkbook.Close (No)

End Sub

used with BPC 7.5 sp5 and office 2007 sp2

... and remember to enable macro.

Kind regards

     Roberto

[Former Member]

Hi Roberto,

Thanks for the method ... but there is something I do not understand, I can create several templates to be used as custom menus in place of the normal custom menus ... right ? or those templates have exactly the same structure ?

But how do I manage the content regarding team I am in ? Because I can me member of different teams that allows me access to different version of menus no ?

Thanks

[former_member186498]

Hi Eric,

I used for some users, to automate the opening of group of templates, that every day used this several time a day and couldn't leave this open for incompatibility but sorry I forgot that custom menus are not simple templates, they have several worksheet  to show the menu and have security check and code to hide the unused workshhet.

As I know there aren't MNU commands for custom menu and I don't think that they will be created because in 10 version custom menu doesn't exist more.

Kind regards

     Roberto