How to Hide and Protect Worksheets

[jrtaylor]

I've got a workbook in which one worksheet is the "Dashboard" and four other sheets run the calcs.

There will only be one or two other people using he Dashboard.

I know that Excel has a method of locking a sheet with a password, but is there also a way for me to hide these other sheets (or if not, just hide their formulas?).



Thanks!

[Roel Jongman]

right next to protect worksheet there is the protect workbook option that can help you to keep sheets with calculation hidden.

https://support.office.com/en-us/art...rs=en-US&ad=US

You can also hide formulas by going to celformatting ( CTRL+1) and on the protection TAB) check Hidden for the cells you want to hide the formulas of and then protect the worksheet

[TMS]

You can hide a sheet by right clicking on the tab and choosing Hide Sheet. Anyone can easily reverse that. Or, you can click on Alt-F11 to go into the VBE and, in the sheet properties, set it to Very Hidden. It's less obvious how to reverse that

[jrtaylor]

Thanks, I appreciate your help.

[TMS]

You're welcome. Thanks for the rep.