The FullPage Macro

Two custom toolbuttons, a FullPage(Portrait) toolbutton and a FullPage(Landscape) toolbutton, were created and positioned on the left side of the Standard toolbar. The FullPage macro was assigned to both buttons, as described earlier. 

When either button is pressed, the macro uses Application.Caller to determine which button was pressed. Application.Caller returns a two-element array, the button position and the toolbar name. These are used to obtain the button caption text. 

This macro uses the ExecuteExcel4Macro method. The Excel 4 Macro PAGE.SETUP executes much faster than its VBA equivalent. 

The button caption text is used to set the orientation argument (the eleventh argument) in the Excel 4 Macro to 1 (for Portrait) or 2 (for Landscape). The first six arguments set the header and footer to null, and the margins to zero. 

---

Some of your macros will be written for a very specific purpose, such as to prepare a specialized report. The workbook containing the macro will be opened only when you want to assemble the report. Other macros automate tasks that you perform often, and you ll want to have them available whenever you re using Excel. These macros should be saved in the Personal Macro Workbook. To make a command macro even easier to use, you can add a custom toolbutton to a toolbar and assign the macro to it. The three macros described in this section — the NumberFormatConvert macro, the FullPage macro and the ChemicalFormat macro — are particularly convenient to use when they are assigned to a button. 

FullPage.xls is a simple command macro that can be used to obtain the maximum amount of space on a page for printing a worksheet. It sets either portrait or landscape orientation, sets margins to zero and removes header and footer text. The macro can be easily assigned to a toolbutton. 

---