Thread: change/set pivot table autofilter criteria with macro button
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default change/set pivot table autofilter criteria with macro button
Excel 2007
Page select macro.
The True statement has to come first:
..PivotItems("Xxxx").Visible = True
My example has charts on separate sheets.
No embedded charts (too difficult)
http://www.mediafire.com/file/zz3gm0wtjdz/03_15_09.xlsm
Reply With QuoteReply With Quote