protecting sheets

[christina]

i have multiple sheets in my workbook. i need to allow certain cells to be
allowed to edit and protect the rest. i need to do the same cells in all the
sheets. is there any quicker way to do this besides going through each
worksheet and clicking on the cells allowed to edit then protecting it... i
need to know if there is some what to do like one and apply to the rest...

 

[Luke M]

Sure thing. Select the first sheet, and then, holding SHIFT, click that last
sheet tab. You now have all the sheets selected. (alternatively, you can use
CTRL to individually select worksheets) Now, select the cells in the current
visible worksheet, format, uncheck the locked option.

Unfortunately, this still requires you to go to each sheet and activate the
protection, unless you want to setup a macro to do it for you. You could then
assign a keyboard shortcut(Alt+F8, options) to the macro to make the whole
process slightly faster.
Basic protection macro:

Sub ProtectMe()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

 

[Gord Dibben]

All sheets protection macro with password.

Sub ProtectAllSheets()
Application.ScreenUpdating = False
Dim N As Single
For N = 1 To Sheets.Count
Sheets(N).Protect Password:="justme"
Next N
Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP