Pondcroft13
New Member
- Joined
- May 27, 2010
- Messages
- 32
Hi All,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
I currently have a macro linked to a button which does the following when someones clicks on it.
<o> </o>
- Filters a pivot table by certain values, then selects the pivot table, then exports to ppt.
<o> </o>
I want to know if there is a way I can add some code to this to remove all filters/selections from the pivot table once this export has been completed. Or failing that – a separate piece of code that I can add to a button that acts a bit like a ‘reset button’.
Kind regards,
Chris
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>I currently have a macro linked to a button which does the following when someones clicks on it.
<o
> </o>- Filters a pivot table by certain values, then selects the pivot table, then exports to ppt.
<o
> </o>I want to know if there is a way I can add some code to this to remove all filters/selections from the pivot table once this export has been completed. Or failing that – a separate piece of code that I can add to a button that acts a bit like a ‘reset button’.
Kind regards,
Chris
