RemoveColorFormatting

Removes potentially distracting color formatting from specified workbook or worksheets.

SYNTAX

expression1.RemoveColorFormatting

expression2.RemoveColorFormatting(BookOrSheets)

expression1   Required.  An expression that returns an IOAKAddIn object.

expression2   Required.  An expression that returns an IOAKAPI object.

BookOrSheets        Required.  One of

•an Excel workbook object

•an Excel worksheet object

•a collection of worksheet objects

•an array of worksheet objects

Remarks

When applied to an IOAKAddIn object, the Remove color formatting method activates the same dialog box as is presented when the Remove color formatting command is selected manually from the OAK user interface.  The action that follows is controlled by the data gathered by the dialog box from the user.

When applied to an IOAKAPI object, the Remove color formatting removes formatting from the workbook or worksheet or worksheets specified by the parameters submitted to the method.

Example

To remove color formatting from the active worksheet:

MyOakApi.RemoveColorFormatting ActiveWorksheet