Hi everyone, i have a spread sheet that has slicers that i have to manually, each month, refresh the data then deselect the past month and select the new one. So i just want to find out whether theres a way for me to automate the whole process, in that i just open the document and it refreshes the data, then does the select and deselect for me.
My slicers have months on them in the format of 'mmm'(e.g Aug).
i tried the code below but it doesnt seem to work. i tried it to set the current month as a trial of seeing whether it will work or not.
ActiveWorkbook.SlicerCaches(Slicer_Dates.Month_Of_Year).SlicerItems("MonthDate").Selected = True
Thank you for reading my post, and thanks for the help
__________________________________________________________________
My slicers have months on them in the format of 'mmm'(e.g Aug).
i tried the code below but it doesnt seem to work. i tried it to set the current month as a trial of seeing whether it will work or not.
ActiveWorkbook.SlicerCaches(Slicer_Dates.Month_Of_Year).SlicerItems("MonthDate").Selected = True
Thank you for reading my post, and thanks for the help
__________________________________________________________________
Mod edit : thread moved to appropriate forum !