how do I restrict access to only one worksheet in excel?

[Avinash]

I want to share an excel workbook for all on the network. However I do not
want one worksheet only to be accessed.
The person should be able to access all the other worksheets.
I tried protecting, but people can see the sheet but cant modify. I tried
adding a password, but with this you can either open the excel file or not.
Is this even possible in Excel?

[Obi-Wan Kenobi]

Not quite sure what you are are asking here.
You tiltle reads "how do I restrict access to only one worksheet in excel?" key word restrict.

You are then aying that you do not wish for only worksheet to be accessed and that they should be able to access all worksheets. please explain?

If you want people to access all the workbooks there is a way of making some cells write enable and protecting others. Is that what you want? (access to ALL workbooks, but with SOME protected cells so the document can not be ammended but others can input data in unprotected CELLS

[bpeltzer]

You should be able to hide the worksheet (with the sheet active, Format >
Sheet >
Hide), the protect the workBOOK. If you like, you can put a password onthe
protection. But realize that there are easy tools out there to crack Excel
passwords, so if the data is truly sensitive, this protection isn't very
secure...


"Avinash" wrote:

> I want to share an excel workbook for all on the network. However I do not
> want one worksheet only to be accessed.
> The person should be able to access all the other worksheets.
> I tried protecting, but people can see the sheet but cant modify. I tried
> adding a password, but with this you can either open the excel file or not.
> Is this even possible in Excel?

[Avinash]

Thanks guys

I will try to explain better...
I want password protect a single worksheet( not an entire workbook) from
actually opening? I have a 2 worksheets one of which should open up with a
password.

As you explained, I was awaare of protecting required cells from being
edited, but I was wanting to protect the worksheet from displaying unless a
password is entered.

Hope this makes sense...


"Obi-Wan Kenobi" wrote:

>
> Not quite sure what you are are asking here.
> You tiltle reads "how do I restrict access to only one worksheet in
> excel?" key word restrict.
>
> You are then aying that you do not wish for only worksheet to be
> accessed and that they should be able to access all worksheets. please
> explain?
>
> If you want people to access all the workbooks there is a way of making
> some cells write enable and protecting others. Is that what you want?
> (access to ALL workbooks, but with SOME protected cells so the document
> can not be ammended but others can input data in unprotected CELLS
>
>
> --
> Obi-Wan Kenobi
> ------------------------------------------------------------------------
> Obi-Wan Kenobi's Profile: http://www.excelforum.com/member.php...o&userid=32578
> View this thread: http://www.excelforum.com/showthread...hreadid=523874
>
>

[Bruce Sinclair]

In article <[email protected]>, =?Utf-8?B?YnBlbHR6ZXI=?= <[email protected]> wrote:
>You should be able to hide the worksheet (with the sheet active, Format >
>Sheet >
>Hide), the protect the workBOOK. If you like, you can put a password onthe
>protection. But realize that there are easy tools out there to crack Excel
>passwords, so if the data is truly sensitive, this protection isn't very
>secure...

Most secure way would be to only send the sheet you want them to see -
delete the other sheet and save it as <a different name> ... and send them
that
If there are calculations on that other sheet that are shown in the one you
want them to see ... I don't know.

>"Avinash" wrote:
>
>> I want to share an excel workbook for all on the network. However I do not
>> want one worksheet only to be accessed.
>> The person should be able to access all the other worksheets.
>> I tried protecting, but people can see the sheet but cant modify. I tried
>> adding a password, but with this you can either open the excel file or not.
>> Is this even possible in Excel?

Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)

[Desert Piranha]

I want to share an excel workbook for all on the network. However I do not
want one worksheet only to be accessed.
The person should be able to access all the other worksheets.
I tried protecting, but people can see the sheet but cant modify. I tried
adding a password, but with this you can either open the excel file or not.
Is this even possible in Excel?

Hi Avinash,
As the previous posters mentioed the best way is, don't include
that sheet with your workbook.

With that said try this:

Password protect the VBA to prevent viewing of your password

Put this into a General Module
Change 'Sheet2' and the password '12345' to suit your needs.

Option Private Module
Sub HideSheet()
Sheet2.Visible = xlSheetVeryHidden
End Sub

Sub ShowSheet()
Dim sPass
sPass = InputBox("Please input password")
If sPass = "12345" Then
Sheet2.Visible = True
End If
End Sub

[sbronste43]

go to save document, then choose prepare then encrypt