I want to password protect my entire spreadsheet allowing others to edit ony
certain cells, can I do this or do I need to protect/unprotect each sheet of
the spreadsheet as I go along?


Angi

Hi,

Select the cells you want to allow editing and then
Format|Cells|Protection Tab
Un-Check 'Locked'
Protect the sheet.

Mike

"Hentzer" wrote:

I want to password protect my entire spreadsheet allowing others to edit ony
certain cells, can I do this or do I need to protect/unprotect each sheet of
the spreadsheet as I go along?


Angi

You can do it with a macro.

Sub ProtectAllSheets()
Application.ScreenUpdating = False
Dim N As Single
For N = 1 To Sheets.Count
With Sheets(N)
.Cells.Locked = True 'set locked on all cells to start
.Range("A1:A10").Locked = False 'set unlocked on a range
.Protect Password:="justme"
.EnableSelection = xlUnlockedCells
End With
Next N
Application.ScreenUpdating = True
End Sub

If your ranges differ on each sheet, you will have to work on each sheet
individually.


Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 04:09:01 -0700, Hentzer
wrote:

I want to password protect my entire spreadsheet allowing others to edit ony
certain cells, can I do this or do I need to protect/unprotect each sheet of
the spreadsheet as I go along?


Angi