Business Planning and Consolidations (BPC)

Relevant versions: BPC5.x+

Using Excel “FORMS” to provide end user initiated function selection capability:

Steps

1. Form the Excel menu View>Toolbars>Forms   The forms toolbar will appear.
2. To create a user selectable “button”, select the form that looks like a grey rectangle.
3. Create the button by moving your cursor to the desired location and trace out the location of the button.  You can always resize and reposition the button at a latter date by access the object’s Format Control.
4. When you create the button, you will be asked to identify a macro for the object.  The macro is the excel program that will be executed when the button is clicked.
5. The following macros are typically used within BPC applications:

           MNU_ETOOLS_REFRESH    

           [Same as “REFRESH WORKBOOK”

           MNU_ESUBMIT_REFRESH   

          [Same as “SEND AND REFRESH SCHELDULE”]  

1. Edit the text of the new button by right clicking on the button outline and selecting  “Edit Text” from the context menu:  
2. Final product:  you now have a “button” that will allow the user to initiate specific actions.