View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Command Button on Pivot Chart

Hi Jay,

I only have the code in a macro, and I want it to be accomplished with a
button on the actual chart. I'd like to remove all macros, if possible.


This is mostly an issue of aesthetics. But I'd like to know if it's even
possible to add the button to the pivot chart and have it float over the
chart, or something similar.


You can add a button from the Forms menu (or a shape from the Drawings
toolbar) and assign a macro to it. But, you still need a macro!

Regards,
Peter T