ScreenSize Property
From Microsoft Excel Visual Basic
ScreenSize Property
Returns or sets the ideal minimum screen size (width by height, in pixels) that you should use when viewing the saved document in a Web browser. Can be one of the MsoScreenSize constants listed below. The default constant is msoScreenSize800x600. Read/write MsoScreenSize.
| MsoScreenSize can be one of these MsoScreenSize constants. |
| msoScreenSize1152x882 |
| msoScreenSize1280x1024 |
| msoScreenSize1800x1440 |
| msoScreenSize544x376 |
| msoScreenSize720x512 |
| msoScreenSize1024x768 |
| msoScreenSize1152x900 |
| msoScreenSize1600x1200 |
| msoScreenSize1920x1200 |
| msoScreenSize640x480 |
| msoScreenSize800x600 |
expression.ScreenSize
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example sets the target screen size at 800x600 pixels.
Application.DefaultWebOptions.ScreenSize = _
msoScreenSize800x600