View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gmead7 gmead7 is offline
external usenet poster
 
Posts: 3
Default Excel PivotChart Field Buttons

I am using Excel 2003. I have a PivotChart with 3 Field Buttons. I want the
user to be able to work with one of the field buttons and I want disable (and
preferably make invisible) the other 2 field buttons. I suspect I may have
to do this through VBA, but haven't been able to find a way to do this yet.
I haven't been able to figure out how to reference the field buttons within
VBA either. I am pre-novice in regards to VBA so I really need the "for
dummies" version (please, be gentle).