To capture the correct code, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTableSelect
If it's not already activated, click on Enable Selection

To select a section of a pivot table, e.g. subtotals --
Move the pointer to the left of a subtotal heading in the pivot table.
When the black arrow appears (like the one that appears when the pointer
is over a row button), click to select the subtotal rows in the pivot
table.

For the header formatting, I'm not clear on what you're trying to achieve.


wacNTN wrote:
Debra,

Thanks again.

On #1, when I record the steps to format the grand total line, the recorded
steps don't include any pivottable specific code. It just looks like
normal range select and selection format code. Any ideas?

When I format the top header, I also format the data selection cell which
sits above the labels for the data area. That cell sticks out like a sore
thumb now. Any ideas?

Thanks,

Walter


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html