DefaultWebOptions Object
TOC
Collapse the table of content
Expand the table of content

DefaultWebOptions Object (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Contains global application-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page. You can return or set attributes either at the application (global) level or at the workbook level.

Workbook-level attribute settings override application-level attribute settings. Workbook-level attributes are contained in the WebOptions object.

Note Note

Attribute values can be different from one workbook to another, depending on the attribute value at the time the workbook was saved.

Use the DefaultWebOptions property to return the DefaultWebOptions object. The following example checks to see whether PNG (Portable Network Graphics) is allowed as an image format and sets the strImageFileType variable accordingly.

Set objAppWebOptions = Application.DefaultWebOptions 
With objAppWebOptions 
 If .AllowPNG = True Then 
 strImageFileType = "PNG" 
 Else 
 strImageFileType = "JPG" 
 End If 
End With
Show:
© 2016 Microsoft