Share via

WebOptions.AllowPNG Property

  • Article
Excel Developer Reference

True if PNG (Portable Network Graphics) is allowed as an image format when you save documents as a Web page. False if PNG is not allowed as an output format. The default value is False. Read/write Boolean.

Syntax

expression.AllowPNG

expression   A variable that represents a WebOptions object.

Remarks

If you save images in the PNG format as opposed to any other file format, you might improve the image quality or reduce the size of those image files, and therefore decrease the download time, assuming that the Web browsers you are targeting support the PNG format.

Example

This example enables PNG as an output format for the first workbook.

Visual Basic for Applications 
  Application.Workbooks(1).WebOptions.AllowPNG = True

Alternatively, PNG can be enabled as the global default for the application for newly created documents.

Visual Basic for Applications 
  Application.DefaultWebOptions.AllowPNG = True

See Also