If the sheet can be invisibe, then you can use this:

Format Sheet Hide

Tools Protection Protect workbook


"Becca" wrote:

I am trying to create a workbook where sheet 1 can be viewed by all but to
click on the other sheet tabs and open the sheet you need to enter a
password. any ideas?