Thanks Dave, I thought it was a long shot. I have written the following code
to password protect the sheet.

Dim MyStr1 As String, MyStr2 As String
MyStr2 = ("engineering")
MyStr1 = InputBox ("Password Required")
If MyStr1 = "" Then Exit Sub
If MyStr1 = MyStr2 Then
Sheets("Parts Spreadsheet").Select
Else
MsgBox "Incorrect Password"
End If

The problem with this is that the user can still access the Parts
Spreadsheet sheet by clicking the sheet at the bottom left corner of the
screen. Is there a way to stop this.

I have tried hiding the sheet but then the macro does not run as it can not
find the sheet. I'm struggling.

Can you help

Cheers


"Dave Peterson" wrote:

> Not really.
>
> I would guess that any suggestion you get would rely on macros. And macros can
> be disabled by the user. So they could see anything they wanted.
>
> On top of that worksheet/workbook protection (via tools|protection) is very
> weak. It's really made to stop errors--not for security. This kind of
> protection can be broken very easily.
>
> If you have data that you don't want others to see, don't put it into excel--or
> don't share that excel file with them.
>
> Nick wrote:
> >
> > I have a program that is password protected when opened, so it can either be
> > opened by a password and be edited or can be opened as read-only. When the
> > file is opened as a read-only is there a way to deny complete access to sheet
> > 2, but when the correct password is entered then all sheets can be viewed.
> > This is becasue sheet 2 has information that is only needed by certain people.
> >
> > Thanks People
>
> --
>
> Dave Peterson
>