Embed Custom GLSU Buttons into a Template

It is useful at times to be able to build a template and add your own buttons for VALIDATE and POST. GLSU allows you to do this quite easily so that your most-used menu actions are embedded in the template.

The first step in this process is to get access to the Developer tab:

1. Go to File > Options.
2. Select Customize Ribbon.
3. On the right pane, select box next to Developer.

   

4. Select OK. The standard Developer tab will be visible on the Excel Ribbon.

   

Now we need a button added to the menu. To do this,

1. Select the Insert icon and insert a button object. Initially the button will be named "Button 1".

   

2. Place your button where you prefer it. Size it if needed. If the button doesn’t have an "edit border" around it then simply right-click on the button to turn on edit mode.

3. In edit mode for the button, look for selection Edit Text in the right-click menu. Name the first button VALIDATE. Now all that is needed is to tie the button to a macro. While in edit mode, select Assign Macro. For the Macro Name enter GLSUValidate and select OK. Test the button by clicking on it. The action should be exactly as though you had clicked on the GLSU Validate menu item.

Create a custom Post button using the same procedure. Simply add a new button as before and right-click on it to get the edit mode, and the edit menu. Edit the text to POST. Again, in edit mode, edit the macro to read GLSUPost. You’re ready to go!

You can go into edit mode (right-click) on any button as needed to change the text, the macro name, or to resize or move the button into place.