Excel: Change Font from PRINT?() Macro Command Causes GP Fault

• Microsoft Excel for Windows, versions 4.0 and 4.0a

SUMMARY

In Microsoft Excel for Windows versions 4.0 and 4.0a, you may receive a general protection (GP) fault (in Microsoft Windows 3.1) or an unrecoverable application error (UAE) (in Microsoft Windows 3.0) when you open the Print dialog box with the PRINT?() macro function, choose the Page Setup button, choose the Header or Footer button, and then choose the Font button.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. This problem was corrected in version 5.0 of Microsoft Excel for Windows.

MORE INFORMATION

When you use the PRINT?() macro command to display the Print dialog box, if you choose the Page Setup button, open the Header or Footer dialog box, select the A button in the Font dialog box, and choose the OK button in each dialog box until you get back to the Print dialog box, you will receive a GP fault or a UAE.

WORKAROUND

To change the style or the point size of the font in your Header or Footer from a macro, use the PAGE.SETUP?() function before the PRINT() or PRINT?() function.

The PAGE.SETUP() command displays the Page Setup dialog box; you can choose the Header or Footer button in this dialog box to make any necessary font changes by selecting the A button. When you choose the OK button in each of the dialog boxes, the PRINT() or PRINT?() command will be executed without any errors.

REFERENCES

"Microsoft Excel Function Reference," version 4.0, pages 312, 334-335