Showing all sheet tabs in a workbook, but only allowing read access with a password

[jonihann]

Can this be done? E. g. Sheet1 and Sheet2 are both shown as tabs, but Sheet2 can't be accessed at all without a password.

 

[Sharid]

Take a look at this External Site Link
OR
This Mr Excel
OR
To hide and show a tab look at this My Post On Mr Excel

 

[jonihann]

Take a look at this External Site Link
OR
This Mr Excel
OR
To hide and show a tab look at this My Post On Mr Excel

The first solution worked great, thanks!

 

[Fluff]

Cross posted Showing all sheet tabs in a workbook, but only allowing read access with a password

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.