EDITION.OPTIONS

Macro Sheets Only

Sets options in, or performs actions on, the specified publisher or subscriber. In Microsoft Excel for Windows, EDITION.OPTIONS also allows you to cancel a publisher or subscriber created in Microsoft Excel for the Macintosh.

Syntax

EDITION.OPTIONS(edition_type, edition_name, reference, option, appearance, size, formats)

Edition_type is the number 1 or 2 specifying the type of edition.

Edition_type Type of edition

1 Publisher

2 Subscriber

Edition_name is the name of the edition you want to change the edition options for or to perform actions on. If edition_name is omitted, reference is required.

Reference specifies the range (given in text form as a name or an R1C1-style reference) occupied by the publisher or subscriber.

Reference is required if you have more than one publisher or subscriber of edition_name on the active workbook. Use reference to specify the location of the publisher or subscriber for which you want to set options.
If edition_type is 1 and the publisher is an embedded chart, or if edition_type is 2 and the subscriber is a picture, reference is the object identifier as displayed in the reference area.
If reference is omitted, edition_name is required.

Option is a number from 1 to 6 specifying the edition option you want to set or the action you want to take, according to the following two tables. Options 2 to 6 are only available if you are using Microsoft Excel for the Macintosh with system software version 7.0 or later.

If a publisher is specified, then option applies as follows.

Option Action

1 Cancels the publisher

2 Sends the edition now

3 Selects the range or object published to the specified edition

4 Automatically updates the edition when the file is saved

5 Updates the edition on request only

6 Changes the edition file as specified by appearance, size, and formats

If a subscriber is specified, then option applies as follows.

Option Action

1 Cancels the subscriber

2 Gets the latest edition

3 Opens the publisher workbook

4 Automatically updates when new data is available

5 Update on request only

The following three arguments are available only when option is 6.

Appearance specifies whether the selection is published as shown on screen or as shown when printed. The default value for appearance is 1 if the selection is a sheet or macro sheet and 2 if the selection is a chart.

Appearance Selection is published

1 As shown on screen

2 As shown when printed

Size specifies the size of a published chart. Size is only available if a chart is to be published.

Size Chart size is published

1 or omitted As shown on screen

2 As shown when printed

Formats is a number specifying the format of the file.

Formats File format

1 or omitted PICT

2 BIFF

4 RTF

8 VALU

You can also use the sum of the allowable file formats. For example, a value of 6 specifies BIFF and RTF.

Example

The following macro formula opens the workbook (and application) that published the edition named Monthly Totals:

EDITION.OPTIONS(2, "Monthly Totals", , 3)

Related Functions

CREATE.PUBLISHER Creates a publisher from the selection

GET.LINK.INFO Returns information about a link

SUBSCRIBE.TO Inserts contents of an edition into the active workbook

List of Command-Equivalent Functions