WebOptions and DefaultWebOptions Members

Use the WebOptions and DefaultWebOptions objects to set the default web publishing options at the application or workbook levels. Use the Application object’s DefaultWebOptions property or the Workbook object’s WebOptions property to get a reference to these objects. The WebOptions and DefaultWebOptions objects have the following members. Key members (shown in bold) are covered in the following reference section:

1 The DefaultWebOptions members are a superset of the WebOptions members. These members apply to DefaultWebOptions only.

AllowPNG

AlwaysSaveInDefaultEncoding 1

Application

CheckIfOfficeIsHTMLEditor 1

Creator

DownloadComponents

Encoding

FolderSuffix

Fonts 1

LoadPictures 1

LocationOfComponents

OrganizeInFolder

Parent

PixelsPerInch

RelyOnCSS

RelyOnVML

SaveHiddenData 1

SaveNewWebPagesAsWebArchives 1

ScreenSize

TargetBrowser

UpdateLinksOnSave

UseLongFileNames

Warning

Excel saves graphics with only noninteractive web pages. Interactive web pages automatically omit pictures, controls, and other Shape objects, and image-related web options have no effect.

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial