Locking/hiding a worksheet that contains data feeding a dashboard

Ok, so I have been searching around a little bit for the answer and unfortunately I haven't had any luck. The absolute best case scenario would be that I could hide and restrict use of all tabs and just use hyperlinks between pages (therefore hiding the one page that I really don't want anyone to see), a less good but serviceable option would be to restrict and/or hide a single sheet.

I've tried just hiding the sheet and protecting the book, but it seems to mess up the dashboard.

Thanks for the help!

Matt

My thoughts went to Very Hidden. You can set on the sheet properties:


xlvhidden.png

You can also manipulate it with vba code, e.g.

Please Login or Register  to view this content.

Awesome, thank you!