Hello
Please can anyone help with the following query?
I have a macro that updates the month and year in a pivot table filter, refreshes the pivot table and then displays the results for a few seconds before looping round to update to the next month in sequence. I've added two buttons to the Excel tab for the user - one to start this macro, and a second to reset the month back to the start once the first macro has run to the end.
Is it possible that I can add a third button that will allow the user to pause the macro on the first click, and then restart the macro by clicking the same button again?
I am a VBA novice so there may well be a simple solution to this, but so far I'm stumped!
Thanks
Kenny
Bookmarks