Hiding a tab in excel so that it cannot be unhidden without knowing password

[Sundance_Kid]

Hi,

I am wondering is it possible to hide a tab in an excel file so that it can only be unhidden with a password for example? The tab contains sensitive data that I don't want people using the file to see. However, I need the tab with the data as there is a lookup working off it.

I know you can hide a tab, but I want to hide it so that it can only be unhidden if you know a password for the tab/file I guess.

Thanks

 

[Fluff]

Two options.
1) Use Workbook protection.
2) Make it very hidden & put a password on the VBA project.

However neither of these are very secure.

 

[Sundance_Kid]

Two options.
1) Use Workbook protection.
2) Make it very hidden & put a password on the VBA project.

However neither of these are very secure.

Thank you for your quick response.

I am not too familiar with VBA so not sure how hard to do that option is?

In terms of Workbook protection, do I just go to Protect Workbook and enter a password?

I need the people that are using the file to be able to input some data in another tab, will they stil be able to do this if the workbook is protected?

Thanks

 

[Fluff]

Yes to both questions.