Alt+F11 to open the VBEditor. Then double-click "ThisWorkbook". Paste code
in right-hand pane. That should do it.

--

"Pamela" wrote in message
...
Hi Guys!!!
I got this macro that adds a password to a spreedsheet:
=============
Private Sub Workbook_Open()
'If you have different passwords
'for each Worksheet.
Sheets(1).Protect Password:="Secret", _
UserInterFaceOnly:=True


Sheets(2).Protect Password:="Carrot", _
UserInterFaceOnly:=True


'Repeat as needed.
End Sub
===============

But I don't where to write the macro to make it work.
please help me,
Pamela XoXo