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


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=523874