Excel 2010 Slicers: VBA to Stop Refresh Until Command Button Pressed

Hello Forum,

Thanks in advance for any ideas/help.

I have 3 slicers (say named One, Two, and Three) on Sheet1 that are all connected to a series of pivot tables (on Sheet2) that run off the same data set. I'm looking for code to "turn off" (disable, set to manual, ??) the refresh action slicers initiate when a selection (or deselection) is made. The use case is that a user of these slicers would make the selections they desire without any refresh of the pivot tables. When ready for the refresh press a command button (Button1) and the results section of Sheet1 then displays the refreshed data.

Hope that makes sense and thanks so much for any help!

Best regards,
Chris

Giving this a gentle, hopeful bump. Thanks. Chris

I'll give this a shot tomorrow Izandol when I'm back at work, thanks for the reply. I think I understand what you're saying, but I'm far from an expert with this stuff, and it seems to make sense. I may have a follow up question but will let you know one way or another. Thank you! Chris