Forum Discussion
Solved
Lock options on a slicer
I am looking to see if there is a way to 'lock' a slicer after a selection is made. We have management reports that span 20 some divisions, and under those twenty divisions are aprox 300 cost cen...
https://www.auditexcel.co.za/blog/excel-slicer-with-password-protection/
There's plenty of information on the web. The above link is just one of them. It shows you what do. I'm on Mac running the latest Excel version and it works pretty much the same for me. I trust you can figure out how to do it in your own schedules.
https://www.auditexcel.co.za/blog/excel-slicer-with-password-protection/
There's plenty of information on the web. The above link is just one of them. It shows you what do. I'm on Mac running the latest Excel version and it works pretty much the same for me. I trust you can figure out how to do it in your own schedules.