AllowPNG Property Example

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

Application.Workbooks(1).WebOptions.AllowPNG = True

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

Application.DefaultWebOptions.AllowPNG = True