XL5: Color List Not Wide Enough to Display 'Automatic'
ID: Q109690
|
The information in this article applies to:
-
Microsoft Excel for Windows, version 5.0
SUMMARY
In Microsoft Excel, the Color list in the Fonts dialog box may not be
wide enough to display the word "Automatic," which is the default color
setting.
MORE INFORMATION
In the Microsoft Visual Basic Programming System, Applications Edition, you
can use the Dialogs and Show methods to display built-in dialog boxes. The
three Visual Basic functions below will display the Fonts dialog box:
Application.Dialogs(xlDialogFont).Show
Application.Dialogs(xlDialogFormatFont).Show
Application.Dialogs(xlDialogReplaceFont).Show
Steps to Reproduce Behavior
- Type the following code into a Module sheet:
Sub Change_Font()
If TypeName(ActiveSheet) = "Worksheet" Then
Application.Dialogs(xlDialogFormatFont).Show
End If
End Sub
- Select a worksheet or macro sheet and run the macro. To run the macro,
choose Macro from the Tools menu, and select the Change_Font macro and
then choose Run.
When the Fonts dialog box is displayed, the Color list may not be wide
enough to display the word "Automatic." The severity of this condition
depends on your screen resolution and video driver.
Additional query words:
5.0
Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :