Random slicer value selected automatically

Dears good afternoon,

I was wondering if someone know a way through VBA to select a value on a slicer randomly and automatically every 2 minutes.
I want to create a dahsboard, visible on TV and to avoid someone to change the value by himself, I am looking for a solution through VBA.

If someone has this kind of solution I will be grateful.

P.S : I still donīt have an excel file. I am just wondering if it is possible and what should be the code in case itīs possible ?

Waiting for your answer
Regards

Stormin good morning

First of all thank you for your help.
This code is working but...

First of all, I am trying to get this code working alone on a loop.
My pivot table is refreshing every 5 mimnutes. What I need is to integrate this code in my routine.

Then, I saw that once the code is selecting all the items in the slicers, is not resetting the slicer.
Instead, itīs going back to the first item in the slicer.
What I was wondering is if you code can reset the slicer and then starting again, selecting the first item ?

See below my code where i need to integrate your code :

Please Login or Register  to view this content.

Actually my code is still not running alone.
I have created a button to run this code.
But has I said above, I need to run this code (alone) every 5 minutes.

If you can help me, I will appreciate.
Regards

Storminī
thank you for your answer
I found what I was looking for.

Just one last question.
In your code, I am wondering how to let the code understand that after every loop selecting item by item, we need to clear the slicer to get all items selected and then once again one by one ?

Can you please help me ?
Regards