Why does the workbook have to password protected?

And do you mean password to open or just password to protect workbook?

You can protect all sheets.

On the one sheet, protect but allow edit ranges.

Just be aware that Excel's internal security is weak and sheet and workbook
passwords easily broken.


Gord Dibben MS Excel MVP

On Mon, 21 Dec 2009 06:37:01 -0800, dwake
wrote:

So my question now is, if the workbook is password protected, will a user
still be able to edit a defined range of cells and have the ability to save?
Or will I have to supply a password so the file does not have to be opened in
read only?

"Paul C" wrote:

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.