You may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

albertmb wrote:

Dear Dave,

Thank you for your help, but I do not have a clue of how to use Macros.
Even though I do a lot of work with Excel what I have learned is by trial and
error, I never studied excel, I might get there if maybe you can explain to
me how to use this macro.

Thank you once again for your time

Regards

Albert

"Dave Peterson" wrote:

Maybe you can use a macro:

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

myPwd = "hithere"
For Each wks In ActiveWorkbook.Worksheets
wks.Protect Password:=myPwd
Next wks
End Sub


albertmb wrote:

Hi Everyone,

I have a 250 sheet project. To protect formulas I have to protect the
sheet, is there a possibility of protecting all sheets in one go, rather than
protecting sheets one at a time?

Thank for anyone who can help me

--

Dave Peterson


--

Dave Peterson