EditionOptions Method

Applies To

Workbook Object.

Description

Sets options for publishers and subscribers in the workbook. Available only on the Apple Macintosh running System 7.

Syntax

object.EditionOptions(type, option, name, reference, appearance, chartSize, formats)

object

Required. The Workbook object.

type

Required. Specifies the edition type to change (either xlPublisher or xlSubscriber).

option

Required. Specifies the type of information to set for the edition. If type is xlPublisher, then option can be one of xlCancel, xlSendPublisher, xlSelect, xlAutomaticUpdate, xlManualUpdate, or xlChangeAttributes. If type is xlSubscriber, then option can be one of xlCancel, xlUpdateSubscriber, xlOpenSource, xlAutomaticUpdate, or xlManualUpdate.

name

Optional. Specifies the name of the edition, as returned from the LinkSources method. If name is omitted, reference must be specified.

reference

Optional (required if name is not specified). Specifies the edition reference as text in R1C1-style form. This argument is required if there is more than one publisher or subscriber with the same edition name in the workbook, or if the name argument is omitted.

appearance

Optional. If option is xlChangeAttributes, specifies whether the edition is published as shown on screen (xlScreen) or as shown when printed (xlPrinter).

chartSize

Optional. If option is xlChangeAttributes and the published object is a chart, specifies the size of the edition (either xlScreen or xlPrinter). If the edition is not a chart, omit this argument.

formats

Optional. If option is xlChangeAttributes, specifies the format of the published edition. Can be any combination of xlPICT, xlBIFF, xlRTF, or xlVALU.