help: how protect formulas in workbook?

  • Thread starter Thread starter spanic
  • Start date Start date
S

spanic

Can we locked cells with formulas from editing in one step?

When I select cells with formulas in all worksheets by selecting all
worksheets and give properties "locked" in Format -Cells-Protection tab
and when I try to protect worksheet by Tools-Protection-Protect Sheet is
not available.

Can we protect all worksheet in workbook in one step or we must do it
sheet by sheet?

Thanks.
spanic
 
If you do it manually, you have to do each sheet separately.

You could use a macro...

Option Explicit
Sub testme()
Dim wks As Worksheet
Dim myPWD As String

myPWD = "hi"
For Each wks In ActiveWorkbook.Worksheets
wks.Protect Password:=myPWD
Next wks
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top