Hello,

Is there any way to create a macro, link that to a button / form control button that would run the macro for a user? I ask because I'm creating a pivot table for large audience to use and instead of using a drop down to sort back to ALL (not all users have 2010 to use the slicer tool) the user could just click a button to run the macro to revert back all sorting to ALL.

Searched on Google & this forum and couldn't find anything similar.

Thanks,

Nick