I had a colleague (actually the First Minion, Erebus) using Modifier with VBA to create a customisation of the Account Maintenance window ( ) in Dynamics GP 2013 R2 (for a client who does not and will not be using the web client). This customisation required a small number of fields and the save button to be added to VBA.
When he was adding the fields everything was fine, but as soon as he tried to add the save button the cursor changed to a standard one and did not allow the save button to be added. Microsoft Dynamics GP 2013 R2 saw the introduction of the action pane (or ribbon bar as I keep on calling it):
This is the first time I’ve tried adding VBA to a button since GP 2013 R2 was released so I was slightly concerned to see this.
I was aware, however, that the action pane can be switched off so via the User Preferences (). There is a field half way down where you can toggle back to the Menu Bar:
We set this to menu bar, logged out of Microsoft Dynamics GP and back in and with the menu bar in Account Maintenance we were able to successfully add the Save button to VBA:
Half the battle was won at this point; VBA added and worked fine on the menu bar, but we needed to check that the VBA still worked on the action pane before we could declare victory. We reset the option in User Preferences, logged out of GP, back in and tested the customisation.
It worked which was good news. All we need to do is remember to make any VBA customisations with the menu bar active instead of the action pane.