Skip to Content
author's profile photo Former Member
Former Member

MNU command to open custom menu ?


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 ...

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on May 31, 2012 at 02:08 PM

    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\<yourCustomMenu>.xlt")

    ThisWorkbook.Close (No)

    End Sub

    used with BPC 7.5 sp5 and office 2007 sp2

    ... and remember to enable macro.

    Kind regards


    Add a comment
    10|10000 characters needed characters exceeded

    • 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


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.