help: how protect formulas in workbook?

[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

 

[Dave Peterson]

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

 

[spanic]

It works!

Thank you so much.

spanic