In the protection section there is the option to Allow Users to Edit Ranges.
You can set a range that an individual user (or network security group) can
edit without using a password.

You can set your protection to allow the use of the outlines, but it is not
one of the options when you protect a sheet. You need to set it up with an
Auto_Open macro

I use this.

Sub Auto_Open()

Count = ActiveWorkbook.Worksheets.Count

For A = 1 To Count
Sheets(A).Unprotect Password:="password"
With Sheets(A)
.Protect Password:="password", AllowFormattingCells:=True,
DrawingObjects:=False, userinterfaceonly:=True
.EnableOutlining = True
.EnableAutoFilter = True
End With
End If
Next A

End Sub

You will need to change the "password" to your sheet password.
Also since there are many different options for protection you may wnat to
protect your sheet with the marco recorder turned on so you get all of your
specific options.

These would replace the
..Protect Password:="password", AllowFormattingCells:=True,
DrawingObjects:=False, userinterfaceonly:=True

the Password:="password", will not be recorded and you must add this yourself
--
If this helps, please remember to click yes.


"dwake" wrote:

I have a couple of questions. I want to protect a workbook, but grant access
to a person to edit one sheet in the workbook. I do not want him to have the
password. I can't seem to find a way to allow him write access without
unprotecting the workbook. I than have to protect each individual sheet, and
grant him access to write going that route.

I am also having problems opening a group and outline tab while a worksheet
is protected.

Anyway around these? Any advice would be appreciated.