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

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

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
------------------------------------------------------------------------
random1970's Profile: http://www.excelforum.com/member.php...o&userid=32112
View this thread: http://www.excelforum.com/showthread...hreadid=518838

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

"random1970" wrote:


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
------------------------------------------------------------------------
random1970's Profile: http://www.excelforum.com/member.php...o&userid=32112
View this thread: http://www.excelforum.com/showthread...hreadid=518838

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

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

"random1970" wrote:


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
------------------------------------------------------------------------
random1970's Profile: http://www.excelforum.com/member.php...o&userid=32112
View this thread: http://www.excelforum.com/showthread...hreadid=518838

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

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).

Fritz wrote:

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

"random1970" wrote:


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
------------------------------------------------------------------------
random1970's Profile: http://www.excelforum.com/member.php...o&userid=32112
View this thread: http://www.excelforum.com/showthread...hreadid=518838



--

Dave Peterson