How do I password protect a single tab in a worksheet in excel ?

  • Thread starter Thread starter Guest
  • Start date Start date
The simple answer here is you probably don't need to.

Just hide the worksheet (Format Menu, Sheet, Hide) and protect the
workbook. That is if you don't want other people to be able to view
it.

If it's OK for people to view it, but not make changes, protect the
worksheet instead. Select the entire worksheet, then Format, Cells,
Protection and Lock all cells. Then protect the worksheet.

Hope this helps.
 
random1970 said:
The simple answer here is you probably don't need to.

Just hide the worksheet (Format Menu, Sheet, Hide) and protect the
workbook. That is if you don't want other people to be able to view
it.

If it's OK for people to view it, but not make changes, protect the
worksheet instead. Select the entire worksheet, then Format, Cells,
Protection and Lock all cells. Then protect the worksheet.

Hope this helps.
Click to expand...
 
Thanks for your suggestion...I probably should have been more clear on my
question. What I am trying to do is password protect just one tab (not the 5
others) from viewing...so that if the file was ever sent to anyone they could
view all but the one tab which would require a password to view ....any
thoughts?

FT
 
Excel's security isn't good enough for this.

If you put something in a workbook, you should assume that it can be read by
anyone who can open that file. All it takes is a bit of curiosity (and to
search google).
 
Back
Top