lock worksheets code

[JasonLeVan]

I have 3 sheets, as soon as the workbook opens i want it to lock worksheets 2 and 3. But then when I go to access it through a macro i want it to unlock them.

Anyone got a code for this

 

[MrKowz]

Try:

Private Sub Workbook_Open()
Sheets("Sheet2").Protect UserInterfaceOnly:=True
Sheets("Sheet3").Protect UserInterfaceOnly:=True
End Sub

The UserInterfaceOnly lines will allow macros to make changes to the sheets without the need to unprotect them.