WebOptions Property

Microsoft Excel Visual Basic

WebOptions Property

       

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.

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.

Set objWO = Workbooks(1).WebOptions
objWO.RelyOnCSS = True
objWO.Encoding = msoEncodingWestern