Workbook.WebOptions Property

  • Article
Excel Developer Reference

Returns the WebOptions collection, which contains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page. Read-only.

Syntax

expression.WebOptions

expression   A variable that represents a Workbook object.

Example

This example specifies that cascading style sheets and Western document encoding be used when items in the first workbook are saved to a Web page.

Visual Basic for Applications 
  Set objWO = Workbooks(1).WebOptions
objWO.RelyOnCSS = True
objWO.Encoding = msoEncodingWestern

See Also