software

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: www.excelforum.com/member.php...oamp;userid=32112
View this thread: www.excelforum.com/showthread...hreadid=518838

quot;random1970quot; wrote:

gt;
gt; The simple answer here is you probably don't need to.
gt;
gt; Just hide the worksheet (Format Menu, Sheet, Hide) and protect the
gt; workbook. That is if you don't want other people to be able to view
gt; it.
gt;
gt; If it's OK for people to view it, but not make changes, protect the
gt; worksheet instead. Select the entire worksheet, then Format, Cells,
gt; Protection and Lock all cells. Then protect the worksheet.
gt;
gt; Hope this helps.
gt;
gt;
gt; --
gt; random1970
gt; ------------------------------------------------------------------------
gt; random1970's Profile: www.excelforum.com/member.php...oamp;userid=32112
gt; View this thread: www.excelforum.com/showthread...hreadid=518838
gt;
gt;

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

quot;random1970quot; wrote:

gt;
gt; The simple answer here is you probably don't need to.
gt;
gt; Just hide the worksheet (Format Menu, Sheet, Hide) and protect the
gt; workbook. That is if you don't want other people to be able to view
gt; it.
gt;
gt; If it's OK for people to view it, but not make changes, protect the
gt; worksheet instead. Select the entire worksheet, then Format, Cells,
gt; Protection and Lock all cells. Then protect the worksheet.
gt;
gt; Hope this helps.
gt;
gt;
gt; --
gt; random1970
gt; ------------------------------------------------------------------------
gt; random1970's Profile: www.excelforum.com/member.php...oamp;userid=32112
gt; View this thread: www.excelforum.com/showthread...hreadid=518838
gt;
gt;

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:
gt;
gt; Thanks for your suggestion...I probably should have been more clear on my
gt; question. What I am trying to do is password protect just one tab (not the 5
gt; others) from viewing...so that if the file was ever sent to anyone they could
gt; view all but the one tab which would require a password to view ....any
gt; thoughts?
gt;
gt; FT
gt;
gt; quot;random1970quot; wrote:
gt;
gt; gt;
gt; gt; The simple answer here is you probably don't need to.
gt; gt;
gt; gt; Just hide the worksheet (Format Menu, Sheet, Hide) and protect the
gt; gt; workbook. That is if you don't want other people to be able to view
gt; gt; it.
gt; gt;
gt; gt; If it's OK for people to view it, but not make changes, protect the
gt; gt; worksheet instead. Select the entire worksheet, then Format, Cells,
gt; gt; Protection and Lock all cells. Then protect the worksheet.
gt; gt;
gt; gt; Hope this helps.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; random1970
gt; gt; ------------------------------------------------------------------------
gt; gt; random1970's Profile: www.excelforum.com/member.php...oamp;userid=32112
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=518838
gt; gt;
gt; gt;

--

Dave Peterson