View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pgarcia pgarcia is offline
external usenet poster
 
Posts: 304
Default Run a VB code when you click on the data field of a Pivot Table

Hello all,
When you click on the data the piovt provides, it brings up a new spread
sheet with the data. How can I have a macro run on the new sheet?

thanks