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

A

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?
 
O

Obi-Wan Kenobi

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

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

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

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

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

Bruce Sinclair

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...
Click to expand...

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.

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

Desert Piranha

Avinash said:
I want to share an excel workbook for all on the network. However I d
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.
tried
adding a password, but with this you can either open the excel file o
not.
Is this even possible in Excel?Hi Avinash,
Click to expand...
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 Su
 
Top