View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gcook888 Gcook888 is offline
external usenet poster
 
Posts: 1
Default PivotTables' name? And the PivotChart

This could be the dumbest question of all time:

In Access I can right click on things and pick up Properties from the shortcut
menu. Most objects have a name property.

I have an Excel PivotTable and PivotChart on Sheet1. I have a PivotChart by
itself on ChartSheet Chart1.

The ObjectBrowser isn't too helpful (yet). I thought (from seeing Access way)
that Sheet1 would show as a member the PivotTable. But it doesn't.

I'd like to program VBA with the PivotChart and PivotTable but I don't even
know what to call them. HOW CAN I REFER TO THEM IN CODE?

They seem to be like the Charts made w/Microsoft Graph 2000 in Access. Are
they that?