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

[Fritz]

[random1970]

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.

[Fritz]

"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
>
>

[Fritz]

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]

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