ScreenSize Property

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