Hello, I have created an excel dashboard that will be shared with colleagues and I would like to hide all the database and working sheets only showing the dashboard sheet.
Understand that there is an option of setting the sheets as very hidden, but my concern is anyone who knows about this function would know how to unhide it (some detailed information that I rather they do not see). I have also tried to password protect each sheet before setting as very hidden so that the data in each sheet cannot be easily extracted should anyone be able to unhide it. But the problem with password protecting every sheet is that the slicers on the dashboard sheet no longer works.
Is there any other way around this?
Thanks
Ying Si
Resolved!
When adding password to protect sheet, select only "Use Autofilter" and "Use PivotTable and PivotChart"